title: sql search results by month in format 2010-04-01 10:40:20
body: <p>How can i select all rows where the month is 04 from 2010 where the format of the date column is as follows: 2010-04-01 10:40:20 using mysql</p>