select dhhm from phone where length(dhhm)=4可以查到内线的,我想可以建立view让用户查找不同的view以获得不同的dhhm
create view v1 as select dhhm from phone where length(dhhm)=4
create view v2 as select dhhm from phone where length(dhhm)=7
create view v3 as select dhhm from phone where length(dhhm)=11
create view v1 as select dhhm from phone where length(dhhm)=4
create view v2 as select dhhm from phone where length(dhhm)=7
create view v3 as select dhhm from phone where length(dhhm)=11
select * from phone where lenght(number)=7;
select * from phone where lenght(number)=11;
select number from phone where number<10000;
select * from phone where lenght(number)=4;
else if flag =2 then
select * from phone where lenght(number)=7;
else if flag = 3 then
select * from phone where lenght(number)=11;
else
select * from phone
end ifflag 是内线,外线,手机的区分