请问mysql能用正侧么?

Question

顶
打错
正则
能用

Answer 1

可以使用正则表达式，见下例
mysql> select 'red' regexp 'red|green|blue','hammer' regexp 'ham$';
+-------------------------------+------------------------+
| 'red' regexp 'red|green|blue' | 'hammer' regexp 'ham$' |
+-------------------------------+------------------------+
| 1                             | 0                      |
+-------------------------------+------------------------+
1 row in set (0.01 sec)