[mythtvnz] Best custom record statements?

[Steve Hodge]

On Fri, Nov 7, 2008 at 11:53 AM, Dean Pemberton <dean at deanpemberton.com> wrote:
> I think from memory that LIKE might be case sensitive.  Please correct me if
> I'm wrong.
>
> As a matter of course I tend to put UPPER around things to control this
> which would make your statements start to look like
>
> UPPER(program.title) LIKE '%DIRECTED BY%' OR .....

Or, if you don't want to have to capitalise everything you can use
lower() instead. I've never understood why so many people seem to
prefer upper() for this...

Cheers,
Steve