如何在此SQL查询中添加WHERE语句 - How to add WHERE statement to this SQL query

How to add WHERE statement to this SQL query

本文关键字：添加 WHERE 语句查询 SQL | 更新日期: 2023-09-27

我试图添加一个where语句到这个查询，所以它只显示已被设置为发布的记录。

$query = "SELECT id, heading, summary, date, keyword1, keyword2, keyword3
     FROM " . DB_TABLE . "";

我试过了

$query = "SELECT id, heading, summary, date, keyword1, keyword2, keyword3, publish
     WHERE publish ='y' FROM " . DB_TABLE . "";

和

$query = "SELECT `id`, `heading`, `summary`, `date`, `keyword1`, `keyword2`, `keyword3`, `publish`
   WHERE `publish` ='y' FROM " . DB_TABLE . "";

但似乎没有一个工作，任何帮助非常感谢，谢谢

这个怎么样:

$query = "SELECT `id`, `heading`, `summary`, `date`, `keyword1`, `keyword2`, `keyword3`, `publish` FROM " . DB_TABLE . " WHERE `publish` ='y' ";

如果你看一下MySQL文档，你会发现SELECT语句在前面，然后是FROM语句，WHERE语句在最后。当然，还有其他各种语句可以使用，您可以在上面的链接

中找到它们。