[mythtv-users] Recordings from nonexistent channels

Jan Ceuleers jan.ceuleers at gmail.com
Tue Jul 31 18:17:22 UTC 2012


On 07/31/2012 06:19 PM, Jan Ceuleers wrote:
> mysql> select * from channel where channum='2019';
> Empty set (0.00 sec)
> 
> Which other tables should I consult? (Is there a way to query the schema for tables that contain a certain column name?)

Answering my own question:

mysql> select table_name from information_schema.columns where lower(column_name)='channum';
+------------+
| table_name |
+------------+
| channel    |
+------------+
1 row in set (0.08 sec)




More information about the mythtv-users mailing list