[mythtv] [mythtv-commits] mythtv commit: r8887 - in trunk/mythplugins/mythweb by xris

[Stuart Morgan]

On Wednesday 08 Feb 2006 18:30, Pekka Jääskeläinen wrote:
> SELECT *
> FROM program,channel
> WHERE program.chanid = channel.chanid
>       AND lower(program.title) = 'historian huoneissa' AND
> program.starttime = '2006-02-08 20:00:00'
>       AND useonairguide = 1
> LIMIT 1;

Just a small OT point, you don't need to user lower() in the WHERE portion of 
a mysql query. Mysql is already case insensitive in this regard. lower() is 
only used to return a value in lower case.
-- 
Stuart Morgan