首页 > 开发 > MySQL > 正文

SELECT时候,如何跳过带有空值字段的数据项?

2017-09-08 09:11:43  来源:网友分享

以下是我的php代码:,

$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads ORDER BY dateline DESC LIMIT 10"

如果tags是空值,则跳过,该怎么改呢?

解决方案

如果空值是:NULL
则:

$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads WHERE tags IS NOT NULL ORDER BY dateline DESC LIMIT 10"

如果空值是:''

$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads WHERE tags !='' ORDER BY dateline DESC LIMIT 10"