I have a query question.
let's say i have a table that looks like this.
fruit characteristics
Apple red
Apple round
Apple Yellow
Banana Yellow
Banana Long
Banana Green
Now i'm trying to develop a query in which if i want to put characteristics as yellow round, apple will come up.
I tried this
SELECT * FROM table WHERE characteristics='red' AND characteristics='round'
that doesn't seem to do it.. if i replace AND with OR it will give both Apple and Banana. Any suggestions?
let's say i have a table that looks like this.
fruit characteristics
Apple red
Apple round
Apple Yellow
Banana Yellow
Banana Long
Banana Green
Now i'm trying to develop a query in which if i want to put characteristics as yellow round, apple will come up.
I tried this
SELECT * FROM table WHERE characteristics='red' AND characteristics='round'
that doesn't seem to do it.. if i replace AND with OR it will give both Apple and Banana. Any suggestions?