Home > Article > Backend Development > SELECT时候，如何跳过带有空值字段的数据项？
SELECT时候，如何跳过带有空值字段的数据项？
- WBOYOriginal
- 2016-06-06 20:51:181567browse
以下是我的php代码：，
$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads ORDER BY dateline DESC LIMIT 10"
如果tags是空值，则跳过，该怎么改呢？
回复内容：
以下是我的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"
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：BAE平台无法访问数据库Next article：PHP怎么把一张图片透明化