let’s say i have a set column in a table with ‘green’, ‘red’, ‘blue’, ‘orange’ as possible values… how would i go about selecting all of the green and blue rows in a single query? if you don’t understand my question you probably can’t help me but to dumb things down a little here’s what i want that doesn’t work:
SELECT * FROM colors WHERE color = ‘green’ AND color = ‘blue’
