如何在Mysql中查询字段不为空的数据项？

Question

$sql = "SELECT uid,user,email,subject,sex,age,address FROM user ORDER BY uid DESC LIMIT 10"

如果想查询email不为空值的记录，该怎么改呢？

Answer 1

如果空值是:NULL

则：

$sql = "SELECT uid,user,email,subject,sex,age,address FROM user WHERE email IS NOT NULL ORDER BY uid DESC LIMIT 10"

如果空值是:

$sql = "SELECT uid,user,email,subject,sex,age,address FROM user WHERE email !='' ORDER BY uid DESC LIMIT 10"