一:判断空值
SELECT * FROM `users` where pwd='';
结果:
SELECT * FROM `users` where pwd !='';
结果:
二:判断null值
SELECT * FROM `users` where pwd is NOT NULL;
结果:
SELECT * FROM `users` where pwd is NULL;
结果:
一:判断空值
SELECT * FROM `users` where pwd='';
结果:
SELECT * FROM `users` where pwd !='';
结果:
二:判断null值
SELECT * FROM `users` where pwd is NOT NULL;
结果:
SELECT * FROM `users` where pwd is NULL;
结果: