Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

mysql现在有一个字段code,我现在需要的规则是,前一位(或两位)我提供了固定值,java后台生成的,比如I或IC。然后后四位随意,然后后两位后面的4位java后台也会生成,也是固定的,最后末尾还有三位随意。比如I17 04 0000 000或IC17 04 0000 000
图片描述
难么mysql的select语句怎么写,求大神告知。。。。
PS.1位(两位)固定,四位随意,四位固定,三位随意
select code from xxxx where??


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
331 views
Welcome To Ask or Share your Answers For Others

1 Answer

SELECT code FROM xxxx WHERE code REGEXP '^(I|IC)[0-9]{4}0000[0-9]{3}$';

或者

SELECT code FROM xxxx WHERE code LIKE 'I____0000%' OR code LIKE 'IC____0000___';

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...