[Solved] Is it possible to write this type of query with MySQL?

by

[ad_1]

Maybe this is what you are looking for:

SELECT *
FROM products
WHERE 
    (product_type = "abc" AND (product_price >= 100 AND product_price <= 1000))
    OR (product_type = "def" AND (product_price >= 2500 AND product_price <= 5000))
    OR product_type NOT IN ("abc", "def")

[ad_2]

solved Is it possible to write this type of query with MySQL?