GROUP BY and checking

dominant

Hello all

I have a table with two fields

id and number

each id can have many numbers.

something like that

1 - 45
1 - 77
1 - 675
2 - 24
2 - 455
3 - 556
3 - 566
3 - 6655

I have a couple of numbers and i want to check if that numbers are in the
number fields for a single id

Has anyone an idea on that (without consuming too much memory)?

mrhappiness

SELECT COUNT(id)
FROm tablename
WHERE id = 1 AND number_column IN (45, 77, 675)

if that returns the number of elements you checked in your IN all numbers are present for this id

dominant

the problem is that the id is not serial and is radnom.

mrhappiness

sorry, i don't get, my english is to bad

dominant

i put

SELECT count(id) as count, id FROM table WHERE number IN ($number[0], $number[1], $number[2], $number[3], $number[4], $number[5]) GROUP BY id ORDER BY id

and seems that it works (with unknown id)