SELECT terminal_id FROM bg_person_answer WHERE ( question_id = 1 AND answer_id = 1 ) AND ( question_id = 2 AND answer_id = 5 ) mysql> select * from bg_person_answer where terminal_id = 2; +-------------+-------------+-----------+----------+---------------------+ | terminal_id | question_id | answer_id | freetext | date_time | +-------------+-------------+-----------+----------+---------------------+ | 2 | 1 | 1 | | 2006-11-15 13:25:08 | | 2 | 2 | 5 | | 2006-11-15 13:25:08 | +-------------+-------------+-----------+----------+---------------------+ 2 rows in set (0.00 sec) mysql>