SQL - AND在Like语句之后被忽略

SQL - AND gets ignored after Like STATEMENT

本文关键字：之后语句 Like AND SQL | 更新日期: 2023-09-26

SELECT * FROM cars WHERE carBrand LIKE '%alfa%' OR carModel LIKE '%alfa%'

我在那句话之后的所有内容都被忽略了。我希望能做到这一点。

SELECT * FROM cars
WHERE carBrand LIKE '%alfa%'
OR carModel LIKE '%alfa%' AND carType = 'truck'

AND carType = 'truck'

SELECT * FROM cars 
WHERE (carBrand LIKE '%alfa%' OR carModel LIKE '%alfa%')
AND carType = 'truck'

AND的结合力比OR强。它叫做运算符优先级。如果没有括号，查询将编译为

SELECT * FROM cars 
WHERE carBrand LIKE '%alfa%' 
OR (carModel LIKE '%alfa%' AND carType = 'truck')