[mythtvnz] Power Search win - TVNZ guide data lose

[Dean Pemberton]

So ER is back on TV now.
It must be the most infuriating show to show to write recording rules 
for because the name is so short and EVERY show seems to have an "er" in 
it. =)
Unfortunately you have to write these rules with so much latitude in 
them because TVNZ tends to play fast and loose with the EIT data (CSI vs 
C.S.I vs Crime Scene Investigation).

This has to be the longest power search I have done to date.

(UPPER(program.title) LIKE "ER%" or UPPER(program.title) LIKE "E.R%"or 
UPPER(program.title) LIKE "EMERGENCY%ROOM%")  AND channel.callsign like 
"TV2" AND DAYOFWEEK(program.starttime) = "5" AND HOUR(program.starttime) 
 >= 18 AND HOUR(program.starttime) < 23

Additions welcome =)


Dean