Uzytkownik "ThanksButNo" <no.no.thanks@gmail.com> napisal w wiadomosci
news:79a584ca-df4a-45f3-af80-f7030f38931c@s8g2000prg.googlegroups.com...
> On Mar 28, 8:40 am, "canaj...@gmail.com" <canaj...@gmail.com> wrote:
>> I have a field that stores one of three possible answers: yes, no,
>> maybe
>>
>> and I know that if I write:
>>
>> SELECT *
>> FROM table
>> WHERE field = "yes"
>>
>> I will get all the records where the field = yes, but how do I get it
>> to return all the records when the field equal yes or maybe
>>
>> thanks
>
> SELECT *
> FROM table
> WHERE field IN ('yes', 'maybe')


I suggest to check:

SELECT *
FROM table
WHERE field IN ('YES', 'MAYBE', 'yes', 'maybe');

You can try to use some functions like upper, lower. Check what exactly is
inside your column and rows.