mysql> select name, callsign, channum, chanid, freqid, sourceid from channel where name='external'; +----------+----------+---------+--------+--------+----------+ | name | callsign | channum | chanid | freqid | sourceid | +----------+----------+---------+--------+--------+----------+ | External | 1031 | 999 | 1031 | 999 | 2 | +----------+----------+---------+--------+--------+----------+ 1 row in set (0.00 sec)