check if date is greater than selected date in mysql code example

Example: mysql select greater than yesterday

SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)