mysql find replace



UPDATE `table_name`
SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')

update table_name set field_name = replace(
field_name, 'original text',
'replacement text');
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

bSundry Technologiesβ„’ | Yorba Linda, CA 92886 | 1-657-859-1338 | This email address is being protected from spambots. You need JavaScript enabled to view it.
All Content Herein is Copyright Β© and Trademarked (TM). | All rights reserved.