Re: Finding like rows based on one of two fields

[Paul Ille]

Thanks! I'll try that way too.

I was able to get a result I wanted by doing this. I'll see if your way is better.

SELECT pfg.person_id, pfg.game_id
FROM persons_favorite_games pfg
WHERE person_id IN ($personids)
GROUP by game_id
HAVING count(game_id) = $personidcount

$personids is the array with the collection of person_id values
$personidcount is the count of the values in the array