MySQL Replace Function
I’ve needed this a few times lately… very handy.
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
Web Words - Blog
Web Words contains resources useful to web site developers and owners, organized by category and searchable.
Have an item for inclusion here, send it to me.
November 6th, 2008 at 5:14 am
Very handy, I was looking for a way to replace strings in MySQL and your line really helped me.