Shulou(Shulou.com)06/03 Report--

This article mainly introduces "how to use regular expressions in mysql". In daily operation, I believe many people have doubts about how to use regular expressions in mysql. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts about "how to use regular expressions in mysql"! Next, please follow the small series to learn together!

Regular expressions are a powerful way to implement complex searches. Regular expressions describe a set of strings.

The simplest regular expression is an ordinary string. For example, the regular expression hello matches only the string hello.

Regular expressions usually contain some special structure to match multiple different strings.

For example, the regular expression hello| world contains substitution operators| It can match the string hello or the string world.

examples

The character ^matches the beginning of a string, for example:

mysql> SELECT REGEXP_LIKE('fofo', '^fo'); -> 1mysql> SELECT REGEXP_LIKE('tofo', '^fo'); -> 0

The character $matches the end of a string, for example:

mysql> SELECT REGEXP_LIKE('fo\no', '^fo\no$'); -> 1mysql> SELECT REGEXP_LIKE('fo\no', '^fo$'); -> 0 At this point, the study of "how to use regular expressions in mysql" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.