MySQL Query a List of Values
You can use the IN operator
`cat` IN ('12', '18', '30')
You probably forgot to enclose those OR parts into parentheses
SELECT *
FROM `table1`
WHERE `option`='R' and (`cat`='12' or `cat`='18' or `cat`='30')
You can use the IN operator
`cat` IN ('12', '18', '30')
You probably forgot to enclose those OR parts into parentheses
SELECT *
FROM `table1`
WHERE `option`='R' and (`cat`='12' or `cat`='18' or `cat`='30')