Help with Comparing Single Column

[sbroad]

I have an odd kind of problem or so I believe.

I have a join to some groups and the result might look like this

FRANK | CUSTOMER
FRANK | INVENTORY
FRANK | ANYTHING
FRANK | FLOOR
FRANK | COW

How would it be possible to check if both CUSTOMER AND COW exist in that colum, and if so allow it to display.

The problem is, I need to know that FRANK contains both CUSTOMER AND COW both in that column (but on seperate rows)Is this possible?

If it were possible to do something with arrays or something in mysql, problem could be solved I think. But it seems once the data has been generated there is not way to sort through and check the data.

I am using a group table which Links a customer table to its group table and my join displays the data as so.

Thanks

[Lars_Berg]

Yes it is possible

select Name
from t
where groups in ('CUSTOMER','COW')
group by name
having count(distinct groups) = 2