I am currently trying to get all records in a database that have a date of birth set to a future date. But I am not sure how to check the existing values stored and make sure they are greater than/less than today's date.
Currently all I have is,
select * from [table_name]
where [column_name] = .........;
CURDATE() function to get today's date. This will return all records later than today:
SELECT * FROM table WHERE dateColumn > CURDATE()