Like and replace bulk lookup and bulk substitution in MySQL

Bulk find

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 particular set (for example, [^abcdef]).

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

#为要查找的字符串

Replace 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.

return type
If String_Expression (1, 2, or 3) is one of the supported character data types, the character data is returned. If String_Expression (1, 2, or 3) is one of the supported binary data types, the binary data is returned.

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