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:
Maximum length for MySQL TEXT field types
Common MySQL database maintenance command
MySQL 5.5 PDO::__construct(): The server requested authentication method unknown to the client [mysq...
How to import mysql innodb with foreign key constraint error?
How to backup MySQL Database in command line with compression
Turn on MySQL query cache to speed up query performance?
MySQL: Full text search for multiple words
phpmyadmin disable 1440 timeout with auto login
Share this with your friends:-