mysql> SELECT basename FROM recorded WHERE chanid = '1051' AND starttime = '2007-06-18T16:55:00'; Empty set (0.00 sec) mysql> SELECT basename FROM recorded WHERE chanid = '1051' AND starttime like '2007-06-18%'; +-------------------------+ | basename | +-------------------------+ | 1051_20070618185500.mpg | +-------------------------+ 1 row in set (0.00 sec)