Date Functions – Date Diff + Examples

/*
  Select Date Different
  DATEDIFF(Date1, Date2)
*/

SELECT id, name, date, DATEDIFF(CURDATE(), date) AS NumberOfDayes FROM `try`;

SELECT
  id, name, date,
  CONCAT('Registered ', DATEDIFF(CURDATE(), date), ' Days Ago.') AS NumberOfDayes
FROM
  `try`;