在开发中经常会遇到这样的情况,一般空的概念分为两种,一种是null,另一种是空字符串。


//空字符串查询
select laojiujie from ehuanw where shucaijd='';
//空指针查询
select laojiujie from ehuanw where shucaijd is null;

或者:
//空字符串或者空指针
select laojiujie from ehuanw where shucaijd='' or shucaijd is null;