mysql counting occurances in a table

Hi,

Here is a table that I am working with:

PERSON | HAS
--------------------------------------------------------
John | Laptop
John | Cell Phone
John | PS3
Sally | Cell Phone
Sally | Laptop
Jane | Laptop


I want my query to return the set of people who own all 3 items (Laptop, Cell Phone, PS3)....

So in this example above, the only name that should come up is "John"

One catch, this has to be dynamic, so future items can be added to the list. Basically, it's suppose to count all items in the list and see if a person owns all of them.

Please help.

re: mysql counting occurances in a table

Check out the count() function.

re: mysql counting occurances in a table

this is what i have right now and no luck.

re: mysql counting occurances in a table

try something like :

count (has) from my_table where person = john.

re: mysql counting occurances in a table

You can try something like:


Hope this could help.

Thanks,
Lauren