MySql

MySql

Select Record in MySql that Matches Month and Year
Example
SELECT * FROM tb_procedure WHERE MONTH(code_date) = 6 AND YEAR(code_date) = 2017;

The SQL Syntax above will select record whose Month is June and Year is 2017.

 

Result
Month and Year Select MySql