14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→Query by month
(→now) |
m (→Query by month) |
||
| Line 65: | Line 65: | ||
* 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 {{CURRENTYEAR}}-01 */ | * 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 to the `time` field | ||
* 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' | ||
* SELECT * FROM `table_name` WHERE `time` >= '{{CURRENTYEAR}}-01-01 00:00:00' AND `time` <= '{{CURRENTYEAR}}-01-31 59:59:59' | * SELECT * FROM `table_name` WHERE `time` >= '{{CURRENTYEAR}}-01-01 00:00:00' AND `time` <= '{{CURRENTYEAR}}-01-31 59:59:59' | ||