/ Published in: SQL
Expand |
Embed | Plain Text
UPDATE table_name SET COLUMN = REPLACE(COLUMN, 'old_text', 'new_text');
You need to login to post a comment.
andyhartleeds on 10/19/07
mysql replace String text mass
6 people have marked this snippet as a favorite
basicmagic
uisluu
wizard04
jessibird
koorb
fazen
UPDATE table_name SET COLUMN = REPLACE(COLUMN, 'old_text', 'new_text');
You need to login to post a comment.