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