Difference between revisions of "User:Rosenbluh"

From MythTV Official Wiki
Jump to: navigation, search
(started SQL query list)
 
m
Line 1: Line 1:
 
===SQL queries===
 
===SQL queries===
 
*Show episode list and episode numbers for a given show (or shows with similar names):
 
*Show episode list and episode numbers for a given show (or shows with similar names):
:<code>select syndicatedepisodenumber as epnum,title,subtitle from recordedprogram where title like "%<SHOW_NAME_OR FRAGMENT>%" order by title,syndicatedepisodenumber;</code>
+
:<code>select syndicatedepisodenumber as epnum,title,subtitle from recordedprogram where title like "%<SHOW_NAME_OR_FRAGMENT>%" order by title,syndicatedepisodenumber;</code>

Revision as of 20:16, 1 April 2008

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;