MySQL 没有按预期返回

Question

我正在运行以下查询

SELECT * FROM (`default_schemes`) 
WHERE `region` = 'Location1' 
OR `region` = 'Location2' 
OR `region` = 'Location3' 
OR `region` = 'Location4' 
OR `region` = 'Location5' 
OR `region` = 'Location6' 
AND `finance` LIKE '%Equity%' 
OR `guidance` LIKE '%Business Mentoring %' 

这将与财务和指导相匹配，但无论设置什么，都会吸引所有地点，我错过了什么？

Answer 1

SELECT * FROM `default_schemes`
WHERE `region` in ('Location1' ,'Location2' ,'Location3' , 'Location4' , 'Location5' ,'Location6' )
AND (`finance` LIKE '%Equity%' 
OR `guidance` LIKE '%Business Mentoring%');