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 = '2007-06-18%16: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)

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

mysql> Bye