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

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

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%';

1-9长度排序
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'0','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'1','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'2','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'3','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'4','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'5','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'6','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'7','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'8','') ) ) as len from dx order by len desc;
select hao, city, price, (LENGTH(hao) - LENGTH( REPLACE(hao,'9','') ) ) as len from dx order by len desc;

select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'0','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'1','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'2','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'3','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'4','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'5','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'6','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'7','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'8','') ) ) as len from qq order by len desc;
select *, (LENGTH(hao) - LENGTH( REPLACE(hao,'9','') ) ) as len from qq order by len desc;