SELECT * FROM mytable WHERE MONTH(transDate)=month AND YEAR(transDate)=presentYear
If that's a query you do often, I'd also store month and year in extra columns in that database (use a trigger to insert/update the values when a record gets inserted/updated).