महीने के आधार पर तिथि चुनने के लिए MySQL में MONTH() मेथड का उपयोग करें।
उदाहरण
टेबल बनाएं:
mysql> create table DemoTable (
-> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> UserName varchar(10),
-> UserPostMessageDate datetime,
-> UserLikes int
-> );
Query OK, 0 rows affected (0.77 sec)
रिकॉर्ड डालें:
mysql> insert into DemoTable(UserName, UserPostMessageDate, UserLikes) values('John', '2019-01-31', 4560);
Query OK, 1 row affected (0.17 sec)
mysql> insert into DemoTable(UserName, UserPostMessageDate, UserLikes) values('Sam', '2019-06-28', 790);
Query OK, 1 row affected (0.27 sec)
mysql> insert into DemoTable(UserName, UserPostMessageDate, UserLikes) values('Carol', '2019-05-01', 230);
Query OK, 1 row affected (0.18 sec)
mysql> insert into DemoTable(UserName, UserPostMessageDate, UserLikes) values('David', '2019-03-05', 10000000);
Query OK, 1 row affected (0.33 sec)
सभी रिकॉर्ड देखें:
mysql> select * from DemoTable;
आउटपुट
+----+----------+---------------------+-----------+ | Id | UserName | UserPostMessageDate | UserLikes | +----+----------+---------------------+-----------+ | 1 | John | 2019-01-31 00:00:00 | 4560 | | 2 | Sam | 2019-06-28 00:00:00 | 790 | | 3 | Carol | 2019-05-01 00:00:00 | 230 | | 4 | David | 2019-03-05 00:00:00 | 10000000 | +----+----------+---------------------+-----------+ 4 rows in set (0.00 sec)
विशिष्ट महीने (जून = 6) के आधार पर डेटा चुनने की क्वेरी:
mysql> select Id, UserName, UserLikes from DemoTable where MONTH(UserPostMessageDate) = 6;
आउटपुट
+----+----------+-----------+ | Id | UserName | UserLikes | +----+----------+-----------+ | 2 | Sam | 790 | +----+----------+-----------+ 1 row in set (0.00 sec)
संबंधित फंक्शन: YEAR(), DAY(), MONTHNAME() भी उपलब्ध हैं।
