为什么这个MySQL select查询不能与WHERE子句一起使用？

Question

Hello this is driving me crazy. I can't get this query to work with the WHERE clause. It works without it. I have tried everything. I have looked at dozens of websites and dozens of questions here. I can't see anything wrong with this query. But it gives me this error whenever I try to use a WHERE clause:

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `cond` = '1'' at line 4

I have tried it with spaces and without, with single quotes and without, I have tried mysqli. I just can't figure out what the problem is.

Here is the code I currently have:

 $sql = <<<SQL
    SELECT *
    FROM `master_inv`
    ORDER BY `sku`
    WHERE `cond` = '1' 
SQL;

Answer 1

WHERE clause goes before ORDER BY.

$sql = <<<SQL
          SELECT *
          FROM `master_inv`
          WHERE `cond` = '1' 
          ORDER BY `sku`
         SQL;