分类
数据库

手机靓号查询(同号查询)

//AAAABBBB

//AABBCC

//AAAABBBB
SELECT
	*
FROM
	`xk_phone`
WHERE
 `phone` REGEXP '(1111|2222|3333|4444|5555|6666|7777|8888|9999)(1111|2222|3333|4444|5555|6666|7777|8888|9999)$'
ORDER BY
	`id` DESC
//AABBCC
SELECT
	*
FROM
	`xk_phone`
WHERE
 `phone` REGEXP '(11|22|33|44|55|66|77|88|99)(11|22|33|44|55|66|77|88|99)(11|22|33|44|55|66|77|88|99)$'
ORDER BY
	`id` DESC