查询: Where hidden = '0‘

Question

如何使我的搜索表单只列出hidden = '0'; + rest选项的结果？

$stmt = $dbh->prepare("
SELECT *
FROM        users u
LEFT JOIN   menues m
ON          u.user_id = m.restaurant_id
WHERE       (restaurant LIKE CONCAT('%', :term, '%'))
OR          city LIKE CONCAT('%', :term, '%')
");
$stmt->bindParam(":term", $term);
$stmt->execute();   

提前感谢:)

Answer 1

好吧，我希望我能理解你需要什么：

$stmt = $dbh->prepare("
SELECT *
FROM        users u
LEFT JOIN   menues m
ON          u.user_id = m.restaurant_id
WHERE       (((restaurant LIKE CONCAT('%', :term, '%'))
OR          city LIKE CONCAT('%', :term, '%'))
AND         hidden = 0)
");
$stmt->bindParam(":term", $term);
$stmt->execute();   

Answer 2

你能不能不加

AND hidden = '0'

添加到WHERE子句的末尾，这样查询就结束了

.
.
.
WHERE (restaurant LIKE ...
OR city LIKE ...)
AND hidden='0'

顺便说一句，hidden真的是一个基于字符的专栏吗？如果没有，您应该添加hidden=0 (不带单引号)