MySQL bulk replaces the specified field string

MySQL Bulk replace specified field string statement

1. UPDATE data table name SET
2. Field name = replace (field name, ' String to replace ', ' replace with ')
3. WHERE to set conditions;

If the WordPress article "Search engine optimization" to replace all the "search engine marketing", the replacement statement is:

1. UPDATE wp_posts SET
2. Post_content = replace (post_content, ' Search engine optimization ', ' Search engine marketing ');

You can also include substitution criteria in the statement, such as replacing only content with a qualified ID of less than 200:

1. UPDATE wp_posts SET
2. Post_content = replace (post_content, ' Search engine optimization ', ' Search engine marketing ')
3. WHERE ID < 200;

According to different needs, set the replacement conditions, magical magic infinity.

MySQL bulk replaces the specified field string