[RESOLVED] getting 2 things from db column

[msnhockey]

I have a column in a database table called status

status can have 5 different things in it
Healthy, Rookie, Injured, Minors or Retired

I am wanting to get only the Healthy and Rookie players listed

I thought i would need to do something like

status = ('Healthy' AND 'Minors')

but that doesnt work.. I am sure i am just missing something small.
any help or tips is appriciated

[msnhockey]

i got it.. i was close

(status = 'Healthy' OR status = 'Rookie')

[bradgrafelman]

Also note that you could use the IN syntax instead, e.g.:

WHERE status IN ('Healthy', 'Rookie')