A brief description of the Mysql regular expression _mysql

We've learned that MySQL can do fuzzy matching with like ...%.

MySQL also supports the matching of other regular expressions, using the REGEXP operator in MySQL for regular expression matching.

If you know PHP or Perl, it's very easy to operate because MySQL's regular expression matches are similar to those of these scripts.

The regular pattern in the following table can be applied to the REGEXP operator.

Instance

Knowing the above regular requirements, we can write more of our own requirements for SQL statements with regular expressions. Below we will list several small instances (table name: PERSON_TBL) to deepen our understanding:

Find all data in the Name field that starts with ' st ':

mysql> SELECT name from person_tbl WHERE name REGEXP ' ^st ';

Finds all data in the Name field that ends with ' OK ':

mysql> SELECT name from person_tbl WHERE name REGEXP ' ok$ ';

Finds all data that contains the ' Mar ' string in the Name field:

mysql> SELECT name from person_tbl WHERE name REGEXP ' Mar ';

Finds all data in the Name field that starts with a vowel character or ends with an ' OK ' string:

mysql> SELECT name from person_tbl WHERE name REGEXP ' ^[aeiou]|ok$ ';

The above is a small set to introduce the MySQL regular expression, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!