[mythtv-users] Searching for movies from a particular decade

[Nick Morrott]

On 31 January 2010 01:24, Chris Gentle <gentlec at gmail.com> wrote:
> Anyone know how I could search in mythtv or mythweb for movies from a
> certain decade?  For instance, let's say I want to find all the movies from
> the 1940s that air on TCM.  Can this be done?

Sure it can - this is MythTV, after all. Using a power search with the
following search phrase gives me good reuslts for TCM in the UK:

program.category_type LIKE 'movie'
AND
program.airdate >= 1940
AND
program.airdate <= 1949
AND
program.chanid = channel.chanid
AND
channel.name LIKE 'TCM'

Note that this may not be the most optimal query, and I'm sure others
will provide a better example.

Cheers,
Nick

-- 
Nick Morrott

MythTV Official wiki: http://mythtv.org/wiki/
MythTV users list archive: http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin