SELECT terminal_id FROM bg_person_answer WHERE ( question_id = 1 AND answer_id = 1 ) AND ( question_id = 2 AND answer_id = 5 ) mysql> desc bg_person_answer; +-------------+------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------------------+-------+ | terminal_id | int(11) unsigned | NO | MUL | 0 | | | question_id | int(11) unsigned | NO | MUL | 0 | | | answer_id | int(11) unsigned | NO | MUL | 0 | | | freetext | text | YES | | NULL | | | date_time | datetime | NO | | 0000-00-00 00:00:00 | | +-------------+------------------+------+-----+---------------------+-------+