[mythtvnz] 1 News has changed its name

[Stephen Worthington]

On Fri, 28 Jul 2023 01:45:37 -0000, you wrote:

>How about regular expression support ?
>
>".*["oO0|nN|eE3"*|1*.*"nN|eE3|wW|sS5".*
>
>should match any combination of "one news" with any capitalisation,
>spacing, and any surrounding text.
>
>(note- untested)

After my daily EPG update script runs mythfilldatabase, it also runs
an SQL script "epg_fixes.sql", and then runs "mythutil --resched".  In
epg_fixes.sql, I currently have:

select
chanid,starttime,title,subtitle,left(description,20),season,episode,category,seriesid,programid
from program where title="1News At Six" order by programid;
update program set title="1 News At 6pm" where title="1News At Six";

to report and update the current "1 News" problem.  SQL does have
regular expression capabilities, but so far I have only been using =,
LIKE and % type matching.