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.
Character set matching requires the use of Unicode standard character classes. For example, to match Chinese, use \p{Han}.
--- Find all data starting with 'billie' in the k1 field mysql> select k1 from test where k1 regexp '^billie'; +--------------------+ | k1 | +--------------------+ | billie eillish | +--------------------+ --- Find all data ending with 'ok' in the k1 field: mysql> select k1 from test where k1 regexp 'ok$'; +----------+ | k1 | +----------+ | It's ok | +----------+ mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}'); +-----------------------------------------------------------------------------+ | ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}') | +-----------------------------------------------------------------------------+ | 1 | +-----------------------------------------------------------------------------+
REGEXP