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')