I m trying
SELECT * FROM carrecords
WHERE
IF(vehicletype= 'SEDAN',
IF(color='BLACK' AND price <= 10000 ,TRUE,
IF(color='RED' OR color='WHITE',
IF(price<=8000, TRUE,FALSE)
,
IF(price<=7000, TRUE,FALSE)
)
)
,
IF(vehicletype = 'SUV',
IF(color='BLACK',
IF(price<=15000,TRUE,FALSE)
,
IF(price<='14000',TRUE,FALSE)),FALSE)
)