mysql - 多列 WHERE 子句中的 AND 条件

Question

我有两个表

Table 1 = restaurants ( r_id , type , cuisine_bkup ) 
Table 2 = address ( id , r_id , location, address )

我正在应用这个查询

SELECT * 
FROM restaurants r 
RIGHT JOIN addresses a ON a.r_id = r.r_id 
WHERE r.type LIKE 'Cafe' AND a.location LIKE 'Gulberg' AND  r.cuisine_bkup LIKE 'Pizza'
GROUP BY r.r_id

它没有给我结果我应该做什么我想用 AND 条件来做

Answer 1

您可能需要通配符 % 来搜索列中的值，如下所示:

SELECT * 
FROM restaurants r 
RIGHT JOIN addresses a ON a.r_id = r.r_id 
WHERE r.type LIKE '%Cafe%' AND a.location LIKE '%Gulberg%' AND  r.cuisine_bkup LIKE '%Pizza%'
GROUP BY r.r_id

否则另一个选项(我猜是使用 OR 而不是 AND)

SELECT * 
FROM restaurants r 
RIGHT JOIN addresses a ON a.r_id = r.r_id 
WHERE r.type LIKE '%Cafe%' OR a.location LIKE '%Gulberg%' OR r.cuisine_bkup LIKE '%Pizza%'
GROUP BY r.r_id

(另请注意，当且仅当所有三个条件都为真时，您将获得 AND 的结果，即 r.type LIKE 'Cafe' AND a.location LIKE ' Gulberg' AND r.cuisine_bkup LIKE 'Pizza')