sql语句 select num from phone where num REGEXP '00[^0][^0]|11[^1][^1]|22[^2][^2]|33[^3][^3]|44[^4][^4]|55[^5][^5]|66[^6][^6]|77[^7][^7]|88[^8][^8]|99[^9][^9]$';
$guilv_array = array( "AABB" => " and mid(duohang,8,2)%11=0 and mid(duohang,10,2)%11=0 and mid(duohang,8,1)!=mid(duohang,10,1) ", "ABAB" => " and mid(duohang,8,4)%101=0 and mid(duohang,8,1)!=mid(duohang,9,1) ", "ABBA" => " and mid(duohang,9,2)%11=0 and mid(duohang,8,1)=mid(duohang,11,1) and mid(duohang,8,1)!=mid(duohang,9,1) ", "AAA" => " and mid(duohang,9,3)%111=0 ", "ABC" => " and REGEXP '".ABC($num,$num1,3)."$'", "AAAA" => " and mid(duohang,8,3)%1111=0 ", "ABCD" => " and REGEXP '".ABC($num,$num1,4)."$'", "AABBCC" => " and mid(duohang,6,2)%11=0 and mid(duohang,8,2)%11=0 and mid(duohang,10,2)%11=0 and mid(duohang,6,1)!=mid(duohang,8,1) and mid(duohang,8,1)!=mid(duohang,10,1) and mid(duohang,6,1)!=mid(duohang,10,1)", "AAABBB" => " and mid(duohang,6,3)%111=0 and mid(duohang,9,3)%111=0 and mid(duohang,6,1)!=mid(duohang,9,1) ", "ABABAB" => " and mid(duohang,6,6)%10101=0 and mid(duohang,6,2)=mid(8,2)=mid(10,2) and mid(duohang,6,1)!=mid(duohang,7,1) ", "AABBCCDD"=> " and mid(duohang,4,2)%11=0 and mid(duohang,6,2)%11=0 and mid(duohang,8,2)%11=0 and mid(10,2)%11=0 and mid(duohang,4,1)!=mid(duohang,6,1) and mid(duohang,4,1)!=mid(duohang,8,1) and mid(duohang,4,1)!=mid(duohang,10,1) and mid(duohang,6,1)!=mid(duohang,8,1) and mid(duohang,6,1)!=mid(duohang,10,1) and mid(duohang,8,1)!=mid(duohang,10,1) ", "cd" => " and mid(duohang,10,1)=mid(duohang,11,1) ", "AAAAAA" => " and mid(duohang,6,5)%11111=0 ", "ABCDABCD"=> " and mid(duohang,4,4)=mid(duohang,8,4) and mid(duohang,4,1)!=mid(duohang,4,2) and mid(duohang,4,1)!=mid(duohang,5,1) and mid(duohang,4,1)!=mid(duohang,6,1) and mid(duohang,4,1)!=mid(duohang,7,1) and mid(duohang,5,1)!=mid(duohang,6,1) and mid(duohang,5,1)!=mid(duohang,7,1) and mid(duohang,6,1)!=mid(duohang,7,1) ", "AABBB" => " and mid(duohang,7,1)=mid(duohang,8,1) and mid(duohang,9,3)%111=0 and mid(duohang,7,1)!=mid(duohang,9,1) ", "AAAABBBB"=> " and mid(duohang,4,1)!=mid(duohang,8,1) and mid(duohang,4,4)%1111=0 and mid(duohang,8,4)%1111=0 ", "AAABAAAB"=> " and mid(duohang,4,3)=mid(duohang,8,3) and mid(duohang,4,3)%111=0 and mid(duohang,7,1)=mid(duohang,11,1) ", "AABBAABB"=> " and mid(duohang,4,2)=mid(duohang,8,2) and mid(duohang,6,2)=mid(duohang,10,2) and mid(duohang,4,2)%11=0 and mid(duohang,6,2)%11=0 ", "AAAAB" => " and mid(duohang,7,4)%1111=0 and mid(duohang,7,1)!=mid(duohang,11,1) ", "ABCABC" => " and mid(duohang,6,3)=mid(duohang,9,3) and mid(duohang,6,1)!=mid(duohang,7,1) and mid(duohang,6,1)!=mid(duohang,8,1) and mid(duohang,7,1)!=mid(duohang,8,1) ", "AAABB" => " and mid(duohang,7,3)%111=0 and mid(duohang,10,2)%11=0 and mid(duohang,7,1)!=mid(duohang,10,1) ", "ABBABB" => " and mid(duohang,7,2)=mid(duohang,10,2) and mid(duohang,7,2)%11=0 and mid(duohang,6,1)=mid(duohang,9,1) and mid(duohang,6,1)!=mid(duohang,7,1) ", "AAAABB" => " and mid(duohang,6,4)%1111=0 and mid(duohang,10,2)%11=0 and mid(duohang,6,1)!=mid(duohang,10,1) ", "AAAAA" => " and mid(duohang,7,5)%11111=0 ", "AAAB" => " and mid(duohang,8,3)%111=0 and mid(duohang,8,1)!=mid(duohang,11,1) " ); 好吧,没人回答我,自己写完了,但还是感觉很繁琐,如果有高手给更简单方法就更好了,分就给你了,大多经过了测试,有几个还没来的及测试
select num from phone where num REGEXP '00[^0][^0]|11[^1][^1]|22[^2][^2]|33[^3][^3]|44[^4][^4]|55[^5][^5]|66[^6][^6]|77[^7][^7]|88[^8][^8]|99[^9][^9]$';
"AABB" => " and mid(duohang,8,2)%11=0 and mid(duohang,10,2)%11=0 and mid(duohang,8,1)!=mid(duohang,10,1) ",
"ABAB" => " and mid(duohang,8,4)%101=0 and mid(duohang,8,1)!=mid(duohang,9,1) ",
"ABBA" => " and mid(duohang,9,2)%11=0 and mid(duohang,8,1)=mid(duohang,11,1) and mid(duohang,8,1)!=mid(duohang,9,1) ",
"AAA" => " and mid(duohang,9,3)%111=0 ",
"ABC" => " and REGEXP '".ABC($num,$num1,3)."$'",
"AAAA" => " and mid(duohang,8,3)%1111=0 ",
"ABCD" => " and REGEXP '".ABC($num,$num1,4)."$'",
"AABBCC" => " and mid(duohang,6,2)%11=0 and mid(duohang,8,2)%11=0 and mid(duohang,10,2)%11=0 and mid(duohang,6,1)!=mid(duohang,8,1) and mid(duohang,8,1)!=mid(duohang,10,1) and mid(duohang,6,1)!=mid(duohang,10,1)",
"AAABBB" => " and mid(duohang,6,3)%111=0 and mid(duohang,9,3)%111=0 and mid(duohang,6,1)!=mid(duohang,9,1) ",
"ABABAB" => " and mid(duohang,6,6)%10101=0 and mid(duohang,6,2)=mid(8,2)=mid(10,2) and mid(duohang,6,1)!=mid(duohang,7,1) ",
"AABBCCDD"=> " and mid(duohang,4,2)%11=0 and mid(duohang,6,2)%11=0 and mid(duohang,8,2)%11=0 and mid(10,2)%11=0 and mid(duohang,4,1)!=mid(duohang,6,1) and mid(duohang,4,1)!=mid(duohang,8,1) and mid(duohang,4,1)!=mid(duohang,10,1) and mid(duohang,6,1)!=mid(duohang,8,1) and mid(duohang,6,1)!=mid(duohang,10,1) and mid(duohang,8,1)!=mid(duohang,10,1) ",
"cd" => " and mid(duohang,10,1)=mid(duohang,11,1) ",
"AAAAAA" => " and mid(duohang,6,5)%11111=0 ",
"ABCDABCD"=> " and mid(duohang,4,4)=mid(duohang,8,4) and mid(duohang,4,1)!=mid(duohang,4,2) and mid(duohang,4,1)!=mid(duohang,5,1) and mid(duohang,4,1)!=mid(duohang,6,1) and mid(duohang,4,1)!=mid(duohang,7,1) and mid(duohang,5,1)!=mid(duohang,6,1) and mid(duohang,5,1)!=mid(duohang,7,1) and mid(duohang,6,1)!=mid(duohang,7,1) ",
"AABBB" => " and mid(duohang,7,1)=mid(duohang,8,1) and mid(duohang,9,3)%111=0 and mid(duohang,7,1)!=mid(duohang,9,1) ",
"AAAABBBB"=> " and mid(duohang,4,1)!=mid(duohang,8,1) and mid(duohang,4,4)%1111=0 and mid(duohang,8,4)%1111=0 ",
"AAABAAAB"=> " and mid(duohang,4,3)=mid(duohang,8,3) and mid(duohang,4,3)%111=0 and mid(duohang,7,1)=mid(duohang,11,1) ",
"AABBAABB"=> " and mid(duohang,4,2)=mid(duohang,8,2) and mid(duohang,6,2)=mid(duohang,10,2) and mid(duohang,4,2)%11=0 and mid(duohang,6,2)%11=0 ",
"AAAAB" => " and mid(duohang,7,4)%1111=0 and mid(duohang,7,1)!=mid(duohang,11,1) ",
"ABCABC" => " and mid(duohang,6,3)=mid(duohang,9,3) and mid(duohang,6,1)!=mid(duohang,7,1) and mid(duohang,6,1)!=mid(duohang,8,1) and mid(duohang,7,1)!=mid(duohang,8,1) ",
"AAABB" => " and mid(duohang,7,3)%111=0 and mid(duohang,10,2)%11=0 and mid(duohang,7,1)!=mid(duohang,10,1) ",
"ABBABB" => " and mid(duohang,7,2)=mid(duohang,10,2) and mid(duohang,7,2)%11=0 and mid(duohang,6,1)=mid(duohang,9,1) and mid(duohang,6,1)!=mid(duohang,7,1) ",
"AAAABB" => " and mid(duohang,6,4)%1111=0 and mid(duohang,10,2)%11=0 and mid(duohang,6,1)!=mid(duohang,10,1) ",
"AAAAA" => " and mid(duohang,7,5)%11111=0 ",
"AAAB" => " and mid(duohang,8,3)%111=0 and mid(duohang,8,1)!=mid(duohang,11,1) "
);
好吧,没人回答我,自己写完了,但还是感觉很繁琐,如果有高手给更简单方法就更好了,分就给你了,大多经过了测试,有几个还没来的及测试