mysql> select timestampdiff(DAY,'2005-05-01','2007-10-10');
+----------------------------------------------+
| timestampdiff(DAY,'2005-05-01','2007-10-10') |
+----------------------------------------------+
|                                          892 |
+----------------------------------------------+
1 row in set (0.00 sec)

mysql> select timestampdiff(MONTH,'2005-05-01','2007-10-10');
+------------------------------------------------+
| timestampdiff(MONTH,'2005-05-01','2007-10-10') |
+------------------------------------------------+
|                                             29 |
+------------------------------------------------+
1 row in set (0.00 sec)

mysql> select timestampdiff(YEAR,'2005-05-01','2007-10-10');
+-----------------------------------------------+
| timestampdiff(YEAR,'2005-05-01','2007-10-10') |
+-----------------------------------------------+
|                                             2 |
+-----------------------------------------------+
1 row in set (0.00 sec)

mysql>