Anonymous
public text v1 · immutablemysql> 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)