sql problem

i want an sql statment that select from table where prefer has the word auction or cash i tried: $sql="select * from products where prefer like '%cash%' "; and it worked biut i tried: $sql="select * from products where prefer like '%cash%' or prefer like '%auction%' "; but didn't work !!! Rehab M.Shouman ------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------- Express yourself with a super cool email address from BigMailBox.com. Hundreds of choices. It's free! http://www.bigmailbox.com ---------------------------------------------------------------------