query for yesterday and today records from mysql code example

Example: how to get yesterday date in mysql

SELECT SUBDATE(NOW(),1);