This is an old revision of the document!

MythTV

Show the Video Source in the Channel Name

update channel set name = CONCAT(name,' (DVB-C)') where not name like '%DVB-%' and sourceid in (select sourceid from videosource where name = 'DVB-C')  ;
update channel set name = CONCAT(name,' (DVB-T)') where not name like '%DVB-%' and sourceid in (select sourceid from videosource where name = 'DVB-T')  ;
update channel set name = CONCAT(name,' (Kab.)') where not name like '%Kab.%' and not name like '%Analog%' and sourceid in (select sourceid from videosource where name = 'Kabel Analog')  ;