User:Rosenbluh

From MythTV Official Wiki
Revision as of 20:16, 1 April 2008 by Rosenbluh (talk | contribs) (started SQL query list)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQL queries

  • Show episode list and episode numbers for a given show (or shows with similar names):
select syndicatedepisodenumber as epnum,title,subtitle from recordedprogram where title like "%<SHOW_NAME_OR FRAGMENT>%" order by title,syndicatedepisodenumber;