/SQL/Current month mysql query

Current month mysql query

This month mysql where

SELECT *
FROM table 
WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());

1

Source: stackoverflow.com

Get month from database php

echo 'Day' . date('d', strtotime($row['Date']));
echo 'Month' . date('m', strtotime($row['Date']));
echo 'Year' . date('Y', strtotime($row['Date']));

1

Source: stackoverflow.com

Current month mysql query

SELECT 
    * 
FROM `users` 
WHERE MONTH(created_at) = MONTH(now())
   AND YEAR(created_at) = YEAR(now())

0

Source: nicesnippets.com

Similar codes

2 votes233 views1 answer
Mysql virtual column
SQL
0 vote232 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote244 views2 answers
Sql query inner join 3 tables
SQL
1 vote233 views2 answers
Change table name phpmyadmin
SQL
10 votes257 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote224 views1 answer
Get employees if not contains in sql
SQL
9 votes222 views4 answers
Mysql show table fields
SQL
0 vote231 views1 answer
Sql string contains case sensitive
SQL
0 vote210 views1 answer
Mysql date + 1 day
SQL
0 vote240 views1 answer
Show table details postgresql
SQL

Share