[mythtvnz] Prime => Sky Open

[Robert Fisher]

I get:-

mysql> select 
chanid,channum,sourceid,callsign,name,xmltvid,mplexid,serviceid from 
channel where name like '%prime%' or name like '%sky open%' or callsign 
like '%prime%' or callsign like '%sky open%' or serviceid=1406 or 
xmltvid like '%prime%' or xmltvid like '%skyopen%'; 
+--------+---------+----------+----------+----------+---------------------+---------+-----------+ 
| chanid | channum | sourceid | callsign | name | xmltvid | mplexid | 
serviceid | 
+--------+---------+----------+----------+----------+---------------------+---------+-----------+ 
| 10015 | 15 | 1 | Sky Open | Sky Open | prime.freeviewnz.tv | 4 | 1406 
| 
+--------+---------+----------+----------+----------+---------------------+---------+-----------+ 
1 row in set (0.01 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20230909/4a2f6831/attachment.html>