手机号码AAA BBB ABAB 123456789 查询SQL语句

BBBA
select * from dx where SUBSTRINg(hao,9,1)=SUBSTRINg(hao,10,1) and SUBSTRINg(hao,11,1)=SUBSTRINg(hao,10,1) and SUBSTRING
(hao,8,1)!=SUBSTRINg(hao,11,1);  

ABBB
select * from dx where SUBSTRINg(hao,9,1)=SUBSTRINg(hao,10,1) and SUBSTRINg(hao,11,1)=SUBSTRINg(hao,10,1) and SUBSTRING
(hao,8,1)!=SUBSTRINg(hao,11,1);  

ABAB
select * from dx where SUBSTRINg(hao,8,2)=SUBSTRINg(hao,10,2) and SUBSTRINg(hao,8,1)!=SUBSTRINg(hao,11,1); 

select * from dx where hao like '%012%';
select * from dx where hao like '%123%';
select * from dx where hao like '%234%';
select * from dx where hao like '%345%';
select * from dx where hao like '%456%';
select * from dx where hao like '%789%';
select * from dx where hao like '%321%';
select * from dx where hao like '%210%';
select * from dx where hao like '%432%';
select * from dx where hao like '%987%';
select * from dx where hao like '%876%';
select * from dx where hao like '%765%';