SELECT prod_name
FROM products
WHERE prod_name REGEXP '.000'
ORDER BY prod_name;
例1:
找手机号中至少存在3个叠号的号码
select * from `user` where phone REGEXP '[1][359].[0-9]\\1{3}.'
SELECT prod_name
FROM products
WHERE prod_name REGEXP '.000'
ORDER BY prod_name;
例1:
找手机号中至少存在3个叠号的号码
select * from `user` where phone REGEXP '[1][359].[0-9]\\1{3}.'