statement that the database updates the contents of a field section

UPDATE lm_wz Set ' content ' = REPLACE (' content ', '/dbdx/js/', '/js/') WHERE ' content ' like '%/dbdx/js/% '

The Replace function in MySQL directly replaces a specific string in a field in a MySQL database, eliminating the need to write a function to replace it, which is very handy.

MySQL Replace function replace () syntax:

UPDATE ' table_name ' SET ' field_name ' = replace (' Field_name ', ' from_str ', ' to_str ') WHERE ' field_name ' like '%from_str% '

Description

Name of the table_name-table
field_name-Field Name
from_str-the string to replace
to_str-replaced by string

This method is useful for porting a WordPress site, such as updating the Wp-options table using the following SQL statement:

UPDATE ' wp-options ' SET ' option_values ' = REPLACE (' option_values ', ' www.olddomain.com ', ' www.newdomain.com ');

statement that the database updates the contents of a field section