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