find the current date using MySQL

SELECT now();
or
SELECT CURDATE();
or
SELECT CURRENT_DATE();