29. March 2005 09:37
I never knew this function existed. Well I never!
MySQL Replace(), here's the syntax.
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
I've also successfully used nested Replace() functions, as above, within a select statement to reform field values for output.
What would we do without it!
Some more MySQL snippets