一些常用的sql

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where (jian like BINARY '%玄' or zi like BINARY '%玄%') ;

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%水%' or zi like BINARY '%水%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%易' or zi like BINARY '%易%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%益' or zi like BINARY '%益%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%斤' or zi like BINARY '%斤%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%木%' or zi like BINARY '%昜%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%布' or zi like BINARY '%布%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%任%' or zi like BINARY '%任%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%工' or zi like BINARY '%工%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%才' or zi like BINARY '%才%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%歲%' or zi like BINARY '%歲%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%咸' or zi like BINARY '%咸%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%斤' or zi like BINARY '%斤%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%戌' or zi like BINARY '%戌%';

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where jian like BINARY '%疋' or zi like BINARY '%疋%';

select * from sw where end=1;

select count(1) from sw where kx is not null;

select id,zi,zi2,jian,jian2,key1,yin,js,weijs,end from sw where weijs like '@象形%' and end is null;

select * from sw where js like '%足%';

select id,zi,jian,jian2,key1,js,weijs from sw where (jian2 is not null and length(jian) > 0) and (jian2 is null or length(jian2)=0) and (weijs is null or length(weijs) = 0);

#人之足也。在下。从止、口。凡足之屬皆从足。

#㐁