Published in: SQL
UPDATE table_name SET COLUMN = REPLACE(COLUMN, 'old_text', 'new_text');
You need to login to post a comment.
SQL Cookbook
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
andyhartleeds on 10/19/07
mysql replace String text mass
3 people have marked this snippet as a favorite
Published in: SQL
UPDATE table_name SET COLUMN = REPLACE(COLUMN, 'old_text', 'new_text');
You need to login to post a comment.