select * from info where typeid= 1 and xxx is NOT null select * from info where typeid= 1 and xxx is null
select * from info where typeid= 1 and xxx is NOT null select * from info where typeid= 1 and xxx is null
转载于:https://www.cnblogs.com/enych/p/7902754.html