[mythtv-users] Duplicate matching

Jan Ceuleers jan.ceuleers at gmail.com
Wed Feb 26 18:45:49 UTC 2020


On 24/02/2020 19:15, Jan Ceuleers wrote:
> On 24/02/2020 17:33, Stephen Worthington wrote:
>> So duplicate matching is much more an art than a science, and you
>> either need to put in the time to keep track of what is going on, use
>> settings that will cause duplicate recordings but will not miss new
>> ones and then manually cull the duplicates when you need to.
> 
> I've gone with the following inclusion in my daily post-mythfilldatabase
> cleanup run:
> 
> update program set programid=left(concat(title," - ",subtitle),63);
> 
> I made simular updates in the recorded and oldrecorded tables. Seems to
> be working at first glance.

For the benefit of the archive: I had to add the season and episode to
the mix as well, so I now have:

update program set
programid=left(concat(title,"-",subtitle,"-S",season,"X",episode),63);


More information about the mythtv-users mailing list