set to the date today mysql code example

Example 1: get date from now() mysql

You can use CURDATE()

Example 2: mysql set variable to today's date

SELECT CAST(CURRENT_DATE() AS CHAR(50)) INTO @today;
SELECT CAST(DATE_ADD(CURRENT_DATE, INTERVAL -1 DAY) AS DATE) INTO @yesterday;

SELECT @today, @yesterday