[mythtv-users] Custom Schedule for Formula One|Formula 1|F1GP

Nick Rout nick.rout at gmail.com
Mon Mar 21 07:04:33 UTC 2011


On Mon, Mar 21, 2011 at 7:19 PM, David Whyte <david.whyte at gmail.com> wrote:
> On Mon, Mar 21, 2011 at 4:07 PM, Wayne Thomas <waynethomas69 at gmail.com> wrote:
>> I use:
>> (program.title LIKE '%formula 1%'
>> OR program.title LIKE '%F1%'
>> OR program.subtitle LIKE '%formula 1%'
>> OR program.subtitle LIKE '%F1%'
>> OR program.description LIKE '%formula 1%'
>> OR program.description LIKE '%F1%')
>> it does pick up the occasional program that isn't Formula 1 (due to
>> mentioning F1 in the description) but thats on only 3 or 4 a year and can
>> easily be ignored (although they can be worth a watch too if you are F1
>> crazy).
>
> Brilliant.  Thanks heaps!

Actually you might need to include some variations with one instead of
1 (unless mysql's 'like' syntax is that clever)


More information about the mythtv-users mailing list