14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→Query by month
m (→Query by month) |
|||
| Line 44: | Line 44: | ||
** SELECT * FROM `table_name` WHERE YEAR(`time`) = '2014' AND MONTH(`time`) = '1' /*MONTH(`time`) = '1' or MONTH(`time`) = '01' are both ok*/ | ** SELECT * FROM `table_name` WHERE YEAR(`time`) = '2014' AND MONTH(`time`) = '1' /*MONTH(`time`) = '1' or MONTH(`time`) = '01' are both ok*/ | ||
** SELECT * FROM `table_name` WHERE DATE_FORMAT(`time`, '%Y-%m') = '2014-01' | ** SELECT * FROM `table_name` WHERE DATE_FORMAT(`time`, '%Y-%m') = '2014-01' | ||
** SELECT * FROM `table_name` WHERE `time` LIKE '2014-01%' /*find the time records starting with the string 2014-01 */ | |||
** SELECT * FROM `table_name` WHERE date(`time`) between '2014-01-01' AND '2014-01-31' | ** SELECT * FROM `table_name` WHERE date(`time`) between '2014-01-01' AND '2014-01-31' | ||
** SELECT * FROM `table_name` WHERE `time` >= '2014-01-01 00:00:00' AND `time` < '2014-02-01 00:00:00' | ** SELECT * FROM `table_name` WHERE `time` >= '2014-01-01 00:00:00' AND `time` < '2014-02-01 00:00:00' | ||