https://devcodepro.comdevcodepro

MySQL COUNT today week month

SELECT
    *,
    COUNT(IF(date >= curdate(), 1, NULL)) 'todaycount',
    COUNT(IF(yearweek(date) = yearweek(curdate()), 1, NULL)) 'weekcount',
    COUNT(IF(month(date) = month(curdate()), 1, NULL)) 'monthcount',
    COUNT(IF(date <= curdate(), 1, NULL)) 'allcount' 
FROM
    mytable

rated 2 times (2) (0)

comments: 1 / hits: 77 / 2 weeks ago, wed, jan 6, 21, 02:42:50

Comments

How about:

Code:

SELECT
    *,
    SUM(date >= curdate()) as 'todaycount',
    SUM(yearweek(date) = yearweek(curdate())) as 'weekcount',
    SUM(month(date) = month(curdate())) as 'monthcount',
    SUM(date <= curdate()) as 'allcount' 
FROM
    mytable

[#56] Sunday, January 10, 2021, 4:03:20

commented 7 days ago

suppe

Only authorized users can post. Please sign in first, or register a free account

Posted

Jake

Member since Jan 6, 2021

Total Points: 37

Total Code Snippets: 1

Total Comments: 0

Location: Hartford, CT