get number of days between two given dates using MySQL

SELECT DATEDIFF("2007-03-07", "2007-03-01"); // For static dates

SELECT DATEDIFF(ColumnA, ColumnB); // For Table column based dates