|
|
|
| Perl: the Markov chain saw | |
| PerlMonks |
Re: Performing substitutions in MySQLby kgraff (Monk) |
| on Apr 12, 2005 at 14:00 UTC ( [id://447001]=note: print w/replies, xml ) | Need Help?? |
|
MySQL has a bunch of string manipulation functions for example: REPLACE(str,from_str,to_str) Returns the string str with all occurrences of the string from_str replaced by the string to_str. To be able to play around with syntax, make a new column to hold the altered values, then when you get the results you want, delete the original column and rename the new one.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||