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')