SELECT event_date=today() FORMAT JSON SELECT * FROM table WHERE event_date IN ('2000-10-10','2000-10-11','2000-10-12') LIMIT 5 FORMAT JSON SELECT * FROM table WHERE event_date=today() LIMIT 5 FORMAT JSON ------------------------------------ 1: OKOK 2: OK 3: 4: OK 5: 6: OK 7: 8: OK 9: 0: 1: INT: 0: 1: OK 2: OK 3: OK 4: OK 5: OK 6: OK 7: OK 8: OK STRING: 0: OK 1: OK BOOL: 1: OK 2: OK 3: OK 4: OK 5: OK 5: OK 6: 0: event_date>=today()-3-3-3 FORMAT JSON