mysql> desc recorded; +-----------------+------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------------------+-------+ | chanid | int(10) unsigned | NO | PRI | 0 | | | starttime | datetime | NO | PRI | 0000-00-00 00:00:00 | | | endtime | datetime | NO | MUL | 0000-00-00 00:00:00 | | | title | varchar(128) | NO | MUL | | | | subtitle | varchar(128) | NO | | | | | description | text | NO | | NULL | | | category | varchar(64) | NO | | | | | hostname | varchar(255) | NO | | | | | bookmark | tinyint(1) | NO | | 0 | | | editing | int(10) unsigned | NO | | 0 | | | cutlist | tinyint(1) | NO | | 0 | | | autoexpire | int(11) | NO | | 0 | | | commflagged | int(10) unsigned | NO | | 0 | | | recgroup | varchar(32) | NO | MUL | Default | | | recordid | int(11) | YES | MUL | NULL | | | seriesid | varchar(40) | NO | MUL | | | | programid | varchar(40) | NO | MUL | | | | lastmodified | timestamp | NO | | CURRENT_TIMESTAMP | | | filesize | bigint(20) | NO | | 0 | | | stars | float | NO | | 0 | | | previouslyshown | tinyint(1) | YES | | 0 | | | originalairdate | date | YES | | NULL | | | preserve | tinyint(1) | NO | | 0 | | | findid | int(11) | NO | | 0 | | | deletepending | tinyint(1) | NO | MUL | 0 | | | transcoder | int(11) | NO | | 0 | | | timestretch | float | NO | | 1 | | | recpriority | int(11) | NO | | 0 | | | basename | varchar(255) | NO | | NULL | | | progstart | datetime | NO | | 0000-00-00 00:00:00 | | | progend | datetime | NO | | 0000-00-00 00:00:00 | | | playgroup | varchar(32) | NO | | Default | | | profile | varchar(32) | NO | | | | | duplicate | tinyint(1) | NO | | 0 | | | transcoded | tinyint(1) | NO | | 0 | | | watched | tinyint(4) | NO | | 0 | | | storagegroup | varchar(32) | NO | | Default | | +-----------------+------------------+------+-----+---------------------+-------+ 37 rows in set (0.00 sec) select * from recorded where basename='1019_20080711155800.mpg' -> ; +--------+---------------------+---------------------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+---------------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+ | chanid | starttime | endtime | title | subtitle | description | category | hostname | bookmark | editing | cutlist | autoexpire | commflagged | recgroup | recordid | seriesid | programid | lastmodified | filesize | stars | previouslyshown | originalairdate | preserve | findid | deletepending | transcoder | timestretch | recpriority | basename | progstart | progend | playgroup | profile | duplicate | transcoded | watched | storagegroup | +--------+---------------------+---------------------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+---------------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+ | 1019 | 2008-07-11 15:58:00 | 2008-07-11 17:02:00 | Top Gear | | Motoring magazine show with Jeremy Clarkson, James May and Richard Hammond. This week they build their own stretch limos out of the most improbable cars and then use them to take some top celebrities to the Brit Awards. Meanwhile, a good ol' boy Ford Mustang whoops around the test track and Billie Piper is the star in a reasonably priced car. | Transport | mythtv | 0 | 0 | 0 | 1 | 0 | Default | 147 | 103079474 | | 2008-07-11 16:36:58 | 891964684 | 0 | 0 | 0000-00-00 | 0 | 0 | 0 | 0 | 1 | 0 | 1019_20080711155800.mpg | 2008-07-11 16:00:00 | 2008-07-11 17:00:00 | Default | Default | 0 | 0 | 0 | Default | +--------+---------------------+---------------------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+---------------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+ 1 row in set (0.00 sec)