I am looking to query a db having multiple brands of cars then from those results I want to further filter it based on the type of oil they use. I have written the below but it does not work and I am not sure how I can get this done.
I am trying to construct a mysql statement but I can't seem to get it right. I am pretty sure I can't use WHERE twice. Any help will be much appreciated.
SELECT * FROM `details` WHERE brand = 'audi' OR brand = 'toyota' WHERE Oil ='Diesel'