PDA

View Full Version : Trimming the data untill it hits special character


tyou
11-07-2009, 12:06 AM
Is there a way to trim all the characters before it hits a special character.
For example
the table has data such as \\SERVER01\printer01. I do not want to display \\SERVER01\
The output i want is printer01

Please help!

oesxyl
11-07-2009, 12:23 AM
Is there a way to trim all the characters before it hits a special character.
For example
the table has data such as \\SERVER01\printer01. I do not want to display \\SERVER01\
The output i want is printer01

Please help!
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substr

best regards