mysql 查询判断手机号
SELECT * FROM `users` WHERE `user_name` REGEXP "^[1][35678][0-9]{9}$" ORDER BY `reg_time` DESC ;
还有一种含有手机号的情况:
SELECT * FROM `users` WHERE `user_name` REGEXP ".[1][35678][0-9]{9}." ORDER BY `reg_time` DESC;( . 的意思是所有字符)
SELECT * FROM `users` WHERE `user_name` REGEXP "^[1][35678][0-9]{9}$" ORDER BY `reg_time` DESC ;
还有一种含有手机号的情况:
SELECT * FROM `users` WHERE `user_name` REGEXP ".[1][35678][0-9]{9}." ORDER BY `reg_time` DESC;( . 的意思是所有字符)