Friday, February 16, 2007

Find and Replace in Mysql

Simple but very useful MySQL trick...

UPDATE `table` SET `field` = REPLACE (
`field` ,
'{string to find}',
'{replacement string}'
)
Posted by Sam Keen at 8:20 PM

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)