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:-
Advertisements
- For example: I’m going to do string replace at my ‘post_content’ field in ‘wp_posts’ table.
Find: http://www.abc.com
Replace with: http://www.xyx.comYou may run the query below to perform the string replace function:-
UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://www.abc.com','http://www.xyz.com');
- Done. Now all the record in post_content should be updated!
Related posts:
How to restore MySQL database from sql dump file?
Maximum length for MySQL TEXT field types
MySQL: Full text search for multiple words
How to install apache, php, mysql with macport in Mac OS X
How to monitor sql query in mysql?
phpmyadmin disable 1440 timeout with auto login
Common MySQL database maintenance command
How to backup MySQL Database in command line with compression
Share this with your friends:-