sam keen's corner of the web

Find and Replace in Mysql

Written by sam keen on February 16, 2007 — Leave a Comment

Simple but very useful MySQL trick…

UPDATE `table` SET `field` = REPLACE (
`field` ,
‘{string to find}’,
‘{replacement string}’
)

Posted in data storage

Leave a Reply

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

«
»