mysql query between "today and current date" code example Example: mysql check datetime equals date SELECT * FROM `calendar` WHERE DATE(startTime) = '2010-04-29'