mysql> select chanid, channum, sourceid, callsign, name from channel where chanid like '%53%'; +--------+---------+----------+----------+-----------------------------------+ | chanid | channum | sourceid | callsign | name | +--------+---------+----------+----------+-----------------------------------+ | 1053 | 53 | 1 | WPGH | WPGH | | 1353 | 353 | 1 | BLOOM | Bloomberg Television | | 1253 | 253 | 1 | LMN | Lifetime Movie Network | | 1753 | 753 | 1 | NBAP5 | DirecTV - NBA League Pass - NBAP5 | | 1853 | 853 | 1 | XMFRNKP | Audio XM: Frank's Place | | 1530 | 530 | 1 | EMYST | Encore Mystery | | 1531 | 531 | 1 | EDRA | Encore Drama | | 1532 | 532 | 1 | EACT | Encore Action | | 1533 | 533 | 1 | EWAM | Encore Wam | | 2531 | 53.1 | 2 | WPGH-DT | WPGH-DT | | 2532 | 53.2 | 2 | WPGH-DT | WPGH-DT | +--------+---------+----------+----------+-----------------------------------+ 11 rows in set (0.01 sec)