Another post about fixing mythfill channels with scan data

pchdtv.com :: View topic - hd3000 dvb setup in mythtv: "The myth scan for DVB channels returns useful information, but the channel names don't match,
so this information has to be transferred over, which is why I spent a good part of today getting the hang of mysql and mysql-browser. What is (sortof) working for me are the following table entries:

mysql> SELECT chanid,channum,freqid,sourceid,callsign,name,
xmltvid,mplexid,serviceid,atscsrcid FROM `channel` where sourceid=2;
+--------+---------+--------+----------+----------+
--------------------+---------+---------+-----------+-----------+
| chanid | channum | freqid | sourceid | callsign | name | xmltvid | mplexid | serviceid | atscsrcid |
+--------+---------+--------+----------+----------+
--------------------+---------+---------+-----------+-----------+
| 2014 | 4_1 | 28-1 | 2 | WNBCDT | WNBCDT (WNBC-DT) | 20459 | 23 | 3 | 2 |
| 2015 | 4_2 | 28-2 | 2 | WNBCDT2 | WNBCDT2 (WNBC-DT2) | 44936 | 23 | 4 | 1 |
| 2016 | 5_1 | 44-1 | 2 | WNYWDT | WNYWDT (WNYW-DT) | 20360 | 32 | 3 | 3 |
| 2017 | 2_1 | 56-1 | 2 | WCBSDT | WCBSDT (WCBS-DT) | 16689 | 37 | 1 | 1 |
| 2018 | 5_2 | 44-2 | 2 | WNYWDT2 | WNYWDT2 (WNYW-DT2) | 30763 | 32 | 4 | 4 |
| 2019 | 7_1 | 45-1 | 2 | WABCDT | WABCDT (WABC-DT) | 20453 | NULL | NULL | NULL |
| 2020 | 9_1 | 38-1 | 2 | WWORDT | WWORDT (WWOR-DT) | 26566 | 32 | 4 | 4 |
| 2021 | 11_1 | 33-1 | 2 | WPIXDT | WPIXDT (WPIX-DT) | 20373 | 27 | 3 | 3 |
+--------+---------+--------+----------+----------+
--------------------+---------+----"