Another newbie question - using OR in WHERE clauses

[Paul Fine]

Is there a simpler way to write something like:

 

SELECT  * FROM tablename

WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty'

 

 

Clearly this does not work:

WHERE columname = 'Bob' OR 'Mike' OR 'Betty' 

 

 

Thanks!