On Fri, 28 Mar 2008 08:40:51 -0700 (PDT), canajien@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

Look up the logical construct "OR" in combination with SELECT.

We hope you get an A on your quiz.

--
58. If it becomes necessary to escape, I will never stop to pose dramatically
and toss off a one-liner.
--Peter Anspach's list of things to do as an Evil Overlord