mysql查询条件字段中数字开始

参考以下方法

要查找以数字开头的字符串，请使用正则表达式。让我们首先创建一个表-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')

可以肯定用[0-9]是不行的，应该下面这样：

SELECT * FROM WEB.CLUBUSER WHERE USER REGEXP '^[0-9]'

上面的语句是刚才我查询我网站中数字开头的注册用户，运行成功的。REGEXP是正则表达式语法，无需定界符。

select REVERSE(right(REVERSE(filename),length(filename)-LEAST(

if(Locate('0',REVERSE(filename)) >0,Locate('0',REVERSE(filename)),999),

if(Locate('1',REVERSE(filename)) >0,Locate('1',REVERSE(filename)),999),

if(Locate('2',REVERSE(filename)) >0,Locate('2',REVERSE(filename)),999),

if(Locate('3',REVERSE(filename)) >0,Locate('3',REVERSE(filename)),999),

if(Locate('4',REVERSE(filename)) >0,Locate('4',REVERSE(filename)),999),

if(Locate('5',REVERSE(filename)) >0,Locate('5',REVERSE(filename)),999),

if(Locate('6',REVERSE(filename)) >0,Locate('6',REVERSE(filename)),999),

if(Locate('7',REVERSE(filename)) >0,Locate('7',REVERSE(filename)),999),

if(Locate('8',REVERSE(filename)) >0,Locate('8',REVERSE(filename)),999),

if(Locate('9',REVERSE(filename)) >0,Locate('9',REVERSE(filename)),999)

)+1)),filename

from homework

---