MySQL has a built in function to perform string replace (just like PHP str_replace) thru the query. I just perform a MySQL string replace at a website migration and everything work like a charm. This MySQL string replace function really save me a lot of time! Imagine if i’m going to edit the record one by one, and there is 100 record, i think i’m going to be crazy after the manual edition.
To perform string replace (str_replace) in MySQL, you can use the query below:-
Continue reading How to do string replace (str_replace) in MySQL »