要查找以数字开头的字符串,请使用正则表达式。让我们首先创建一个表-
mysql> create table DemoTable ( Id varchar(200) );
使用插入命令在表中插入记录-
mysql> insert into DemoTable values('123User'); mysql> insert into DemoTable values('_$123User'); mysql> insert into DemoTable values('User123456'); mysql> insert into DemoTable values('0000User'); mysql> insert into DemoTable values('&^*User');
使用选择命令显示表中的记录-
mysql> select *from DemoTable;
这将产生以下输出-
+------------+ | Id | +------------+ | 123User | | _$123User | | User123456 | | 0000User | | &^*User | +------------+ 5 rows in set (0.00 sec)
这是使用MySQL Regexp查找以数字开头的字符串的查询-
mysql> SELECT DISTINCT Id FROM DemoTable WHERE Id REGEXP '^[0-9]';
这将产生以下输出-
+----------+ | Id | +----------+ | 123User | | 0000User | +----------+ 2 rows in set (0.58 sec)