[mythtv-users] Duplicate detection

[Michael T. Dean]

On 09/19/2016 02:06 PM, Jan Ceuleers wrote:
> Record at any time from any channel, search type = power search,
> additional tables: <none>, search phrase:
>
> ((lower(channel.callsign) in
> ('2be','vt4','vtm','een','ketnet/canvas','canvas','ned1','ned3','nos1','nos2','nos3','vijftv','acht','canvas')
> OR lower(channel.callsign) like 'bbc%')) AND lower(program.category) in
> ('film','movie','action','romance','crime','comedy','western','drama','tv
> movie','mystery','historical/period drama','literary adaptation', 'war',
> 'musical', 'crime drama') AND TIMESTAMPDIFF(MINUTE, program.starttime,
> program.endtime) >= 70 AND program.airdate >= 1970
>
>

BTW, no need for lower() function on any of those fields since 
program.category is utf8 character set (not utf8-bin) and we're using 
utf8_general_ci collation for the whole database (where "ci" means 
case-insensitive).

Mike