mysql> select channum, freqid, sourceid from channel where channum in (6, 7, 19, 20, 21, 22); +---------+--------+----------+ | channum | freqid | sourceid | +---------+--------+----------+ | 7 | 7 | 1 | | 20 | 20 | 1 | | 6 | 6 | 1 | | 19 | 19 | 1 | | 21 | 21 | 1 | | 22 | 22 | 1 | +---------+--------+----------+ 6 rows in set (0.04 sec)