Mysql Function: The difference between two dates in months

To find the different between 2 dates in months:

Use PeriodDiff mysql function
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_period-diff


Example:
select period_diff(date_format(date1row, '%Y%m'), date_format(date2row, '%Y%m')) as months from your_table;