How to use the regexp_replace function in mysql

This article mainly introduces "how to use the regexp_replace function in mysql". In daily operation, I believe many people have doubts about how to use the regexp_replace function in mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to use the regexp_replace function in mysql". Next, please follow the editor to study!

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 | +-- -+ so far The study on "how to use the regexp_replace function in mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!