The RegExp function in MySQL can match regular expressions in peacetime when using SQL, and you can use the RegExp function to match the corresponding characters when using some query conditions, which can replace many of the SQL functions that you are unfamiliar with or do not understand, and thus improve your daily productivity. The RegExp function under MySQL is very simple to use, the meta-character of the regular expression can be see: The Http://jim123.blog.51cto.com/4763600/1850919,REGEXP function return value is a Boolean value of 0 and 1, that is, the match is 1, Not worthy of 0, such as:
mysql> SELECT ' monty! ' REGEXP ' ^o '; +----------------------+| ' monty! ' REGEXP ' ^o ' |+----------------------+| 0 |+----------------------+1 row in Set (0.00 sec) mysql> SELECT ' monty! ' REGEXP ' ^m '; +----------------------+| ' monty! ' REGEXP ' ^m ' |+----------------------+| 1 |+----------------------+1 row in Set (0.00 sec)
This article from "Jim's Technical Essay" blog, reproduced please contact the author!
Using regular expressions in MySQL