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: 733 / 1 year 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 1 year 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: 112

Total Code Snippets: 4

Total Comments: 0

Location: Hartford, CT

Jake snippets

Bootstrap navbar brand background image

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

Check if GET / POST exists

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

count(): Argument #1 ($var) must be of type Countable fix

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