mySQL replace() : find and replace text in existing mySQL data column

This is a really useful function - you can find and replace text in any column of a mySQL database using the " replace() " function.

UPDATE table_name
SET column_name = replace(column_name,'text to find','replacement text');

easy!

 

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
blogcfc 5.9.1.002 by raymond camden
contact michael evangelista