How to use regexp_replace function in mysql
This article mainly shows you "how to use the regexp_replace function in mysql", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to use the regexp_replace function in mysql" this article.
1. The function replaces the substring of the matching pattern pat in the string expr with repl and returns the replacement result.
2. If expr, pat or repl is NULL, the function returns NULL.
The REGEXP_REPLACE () function supports the following optional parameters:
Pos means that the search starts at the specified location of the string expr. The default match starts with the first character.
Occurence indicates the number of matching substrings to be replaced. The default value is 0, which replaces all matching substrings.
Match_type indicates the matching mode, and the parameters are the same as the REGEXP_LIKE () function above.
Example
Mysql > SELECT REGEXP_REPLACE ('a b c', 'baked,' X') +-- + | REGEXP_REPLACE ('a b c', 'b' 'X') | +-+ | a X c | +-+ mysql > SELECT REGEXP_REPLACE (' abc def ghi','[a murz] +', 'Xrays, 1,3) +-- + | REGEXP_REPLACE ('abc def ghi',' [a murz] +', 'Xanthi, 1 3) | +-- + | abc def X | +-- -+ these are all the contents of the article "how to use the regexp_replace function in mysql" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
