求一个mysql的正则。select * from table where title like = '% regex part %';
regex part 由一串字符组成,条件为:开头有3个随机数字或字母,结尾为 abcdefg。即regex part可以是: a4Fabcdefg,Pl9abcdefg,C8Habcdefg.求该正则,谢谢。
regex part 由一串字符组成,条件为:开头有3个随机数字或字母,结尾为 abcdefg。即regex part可以是: a4Fabcdefg,Pl9abcdefg,C8Habcdefg.求该正则,谢谢。
from tb
where title like '^[a-zA-Z0-9]{3}abcdefg$'
from tb
where title like '^[a-zA-Z0-9]{3}.*abcdefg$'
select *
from tb
where title regexp '^[a-zA-Z0-9]{3}.*abcdefg$'