regexp

description

syntax

BOOLEAN regexp(VARCHAR str, VARCHAR pattern)

Perform regular matching on the string str, return true if it matches, and return false if it doesn’t match. pattern is a regular expression.

example

1. // Find all data starting with 'billie' in the k1 field
2. mysql> select k1 from test where k1 regexp '^billie';
3. +--------------------+
4. | k1                 |
5. +--------------------+
6. | billie eillish     |
7. +--------------------+

9. // Find all data ending with 'ok' in the k1 field:
10. mysql> select k1 from test where k1 regexp 'ok$';
11. +----------+
12. | k1       |
13. +----------+
14. | It's ok  |
15. +----------+

keyword

REGEXP