what you would want to do is:

select * from database ;
where field1 = XXX or field1 = YYYY or field1 = ZZZ

you could also say
select * from database where inlist(field1,XXX,YYYY,ZZZ)

hope this helps