select right(a,11) from abc where right(a,11) REGEXP '^[0-9]';
数据:
查询结果:
扩展:select right(a,11) from abc where right(a,11) or right(a,7) REGEXP '^[0-9]'
select right(a,11) from abc where right(a,11) REGEXP '^[0-9]';
数据:
查询结果:
扩展:select right(a,11) from abc where right(a,11) or right(a,7) REGEXP '^[0-9]'