Analysis of MySQL's method of implementing fuzzy string replacement based on regular expressions

This article uses an example to describe how to use MySQL to implement fuzzy string replacement based on regular expressions. Share with you for your reference, the details are as follows:

For example: abcd(efg)hijk after replacement is abcdhijk

After execution, an error is reported: Truncated incorrect DOUBLE value

The solution is that after querying, it was found that the problem was caused by concat(Str,'') function. Some DBs support the + operator, while others do not and must use the concat function.

Modify the SQL as follows:

PS: Here are two very convenient regular expression tools for your reference:

JavaScript regular expression online testing tool:
http://tools.jb51.net/regex/javascript

Regular expression online generation tool:
http://tools.jb51.net/regex/create_reg

Readers who are interested in more MySQL-related content can check out the following topics: "Summary of MySQL Common Functions", "Summary of MySQL Log Operation Skills", "Summary of MySQL Transaction Operation Skills", "Summary of MySQL Stored Procedure Skills" and "Summary of MySQL Database Lock-Related Skills".

I hope this article will be helpful to everyone's MySQL database design.