mysql like 的[]用法

Question

[b]为了演示[]的用法[/b]
mysql> select username from user limit 5;
+----------+
| username |
+----------+
| admin |
| test |
| test1 |
| test2 |
| test3 |
+----------+
5 rows in set (0.00 sec)

mysql> select username from user where username like '%[a-t]%' limit 5;
查找了包含a到t之间的字符
Empty set (0.00 sec)
mysql> select username from user where username like '[t]%' limit 5;
查找t开通的字符
Empty set (0.00 sec)
怎么后面两天找不到数据。

Answer 1

你需要的是正则表达式语法
如
select * from base_customer where customerId regexp '^[t].*' limit 0, 5;