Tue, January 25, 2022
InterServer Web Hosting and VPS
https://devcodepro.comdevcodepro
X
InterServer Web Hosting and VPS
Home · Latest · Trends
2

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: 733  / 1 year ago, wed, jan 6, 21, 02:42:50
More From » SQL
 

Comments

1
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
 
suppe
commented 1 year ago
Only authorized users can post. Please sign in first, or register a free account
Login with Google
 
Share
Posted
Jake
Member since Jan 6, 2021
Total Code Snippets: 4
Total Comments: 0
Location: Hartford, CT
Jake snippets
1 year ago, sun, jan 24, 21, 5:39:27
.navbar-brand { background-image: url(images/logoimage.png); background-repeat: no-repeat; display: block; background-position: left; width: 100%; min-height: 48px; } /* <a class="navbar-brand" href="index.html"></a> */
comments: 0 / hits: 254
CSS
1 year ago, mon, jan 25, 21, 10:13:23
if (!$_POST) { echo 'POST Not Exist'; } else { echo 'POST Exist'; } if (!$_GET) { echo 'GET Not Exist'; } else { echo 'GET Exist'; }
comments: 0 / hits: 250
PHP
12 months ago, tue, feb 23, 21, 1:51:57
<?php if (is_iterable($children)) { foreach ($children as $child) { } } //if ((count($children)) > 0) { //foreach ($children as $child) { //} //} ?>
comments: 1 / hits: 1215
PHP