MySQL string bulk find and replace

Wildcard description
_ and any single character match

% matches a string that contains one or more characters

[] matches any single character in a particular range (for example, [a-f]) or in a specific set (for example, [abcdef]).

[^] matches any single character that is outside a specific range (for example, [^a-f]) or a specific set (for example, [^abcdef])

Batch search:

The code is as follows	Copy Code
SELECT A.products_name from Nike.products_description a WHERE a.products_name like '%#% '

#为要查找的字符串

Bulk Replacement:

REPLACE
Replaces all occurrences of the second given string expression in the first string expression with the third expression.

Grammar
REPLACE (' String_expression1 ', ' string_expression2 ', ' String_expression3 ')

Parameters
' String_expression1 '

The string expression to search for. String_expression1 can be either character data or binary data.

' String_expression2 '

The string expression to find. String_expression2 can be either character data or binary data.

' String_expression3 '

The string expression to replace. String_expression3 can be either character data or binary data.

The code is as follows	Copy Code
UPDATE Article SET content = replace (content, ' Sjolzy ', ' sjolzy.cn ') WHERE name like '%#% ';

Article for table content for fields   Sjolzy for   sjolzy.cn to be replaced