if (type<>'') and (type is not null)
用到where 语句中是这样的这在你不想匹配到数据为空的情况下特别受用,另外有需要的话 再判断下要匹配的字符串是否为空select * from biao where (type<>'' and type is not null and type like '%test%')
if (type<>'') and (type is not null)
用到where 语句中是这样的这在你不想匹配到数据为空的情况下特别受用,另外有需要的话 再判断下要匹配的字符串是否为空select * from biao where (type<>'' and type is not null and type like '%test%')