Code: Select all
SELECT id, title FROM products WHERE category != '%red%' ORDER BY title ASCSo if the category is called "red spot" or "blue and red stripe", it will not show it in the listing.
I thought it would be "DOES NOT CONTAIN" or something like that.
Anyone know?