Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to use the regexp_substr function in mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Return the substring of the matching pattern pat in the string expr. If the matching substring cannot be found, NULL is returned.

2. If expr or pat is NULL, the function returns NULL.

The REGEXP_SUBSTR () 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 how many matching substrings are returned. The first matching substring is returned by default.

Match_type indicates the matching mode, and the parameters are the same as the REGEXP_LIKE () function above.

Example

Mysql > SELECT REGEXP_SUBSTR ('abc def ghi',' [a Murz] +') +-- + | REGEXP_SUBSTR ('abc def ghi' '[amurz] +') | +-- + | abc | +-- + mysql > SELECT REGEXP_SUBSTR ('abc def ghi' '[amurz] +', 1,3) +-+ | REGEXP_SUBSTR ('abc def ghi',' [a Murz] +', 1 3) | +-+ | ghi | +-+ " This is the end of the introduction to how to use the regexp_substr function in mysql. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.