Selecting rows containing 2 values from

[Anon]

Hi.

Please help me with this. I'm really stuck on this one, and I'm sure there's a simple way out of it 🙂

Ok. I want to select all the rows which contain the values 1 and 2 in their "catersfor" field. Is that possible.

I have my query setup this way:

select * from ihrdata where region like 'kerry' and catersfor = 1 or catersfor = 2

But in doing that it seems to produce all the entries in the database! Could someone please help me structure this query correctly? Thanx a million in advance.

[merkinmuffley]

you've got a couple of choices, either parenthesize or use the IN keyword.

select * from ihrdata where region like 'kerry' and (catersfor=1 or catersfor=2)

or

select * from ihrdata where region like 'kerry' and catersfor in (1,2)

hth
/nick

[Anon]

Thanx Nick man..
Sorted out now.