MySQL Find & Replace

Like this blog? Consider exploring one of our sponsored banner ads...

This is a good “oh shit” tool… It’s just a simple way to do a search and replace across all values in a column. It will replace every occurrence in the column so use with caution…

UPDATE `table` SET `column` = REPLACE(`column`, ‘find’,replace)

About this entry