MySQL String Replace
Posted by Michael Dale on Thu, 26 Oct 2006 4:09 PMStuart just moved domains so we wanted to update his entries to link to the correct domain.
The following worked for us:
UPDATE table_name SET column_name = REPLACE(column_name,"original_string","replace_string");
Copyright © Michael Dale 2004 - 2007, 0.0225 Seconds, 7 queries, Powered by a roll of red carpet,
Memory Usage: 935.5 KB
And effective it was. Cheers mate.