56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> select 'aaawfff' regexp '^[^w]*w[^w]*$';
+----------------------------------+
| 'aaawfff' regexp '^[^w]*w[^w]*$' |
+----------------------------------+
| 1 |
+----------------------------------+
1 row in set (0.00 sec)
mysql> select 'aawawfff' regexp '^[^w]*w[^w]*$';
+-----------------------------------+
| 'aawawfff' regexp '^[^w]*w[^w]*$' |
+-----------------------------------+
| 0 |
+-----------------------------------+
1 row in set (0.00 sec)
mysql>
mysql> select ' **testettestestes** ' regexp ' [*]- testettestestes
- [*]
- ';
+----------------------------------------------------------------+
- | ' **testettestestes** ' regexp ' [*]
- testettestestes
- [*]
- '
- |
+----------------------------------------------------------------+
| 1 |
+----------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>