Changing title of many recordings in MythTV

Sometimes I record something that has a way to general title, but I don’t want to have to go through 10 instances of it manually. I use the following SQL statement to change the title based on the subtitle:

UPDATE `mythconverg`.`recorded` SET `title` = 'For Queen and Country' WHERE `subtitle` LIKE '%For Queen and Country%';

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.