22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM test
WHERE mobile LIKE'1[3458]'+REPLICATE('[0-9]',9)
--借楼上
SELECT * FROM test
WHERE mobile LIKE '1'+REPLICATE('[0-9]',10) or model like REPLICATE('[0-9]',4)+'-'+replicate('[0-9]',6)
SELECT * FROM test
WHERE mobile LIKE'1'+REPLICATE('[0-9]',10)