How to compare current date and expired date in MySQL query PHP


I want to know that how can i compare current job and expired date from jobs by which if the expired date exceed the job will get hide ??
I am confused can anyone kindly tell me the code for that ?

WHERE CURDATE() <= jobexpiredate

Something like that?

Yup, i have done some how and that query is showing the dates which are <= current date but now i want to hide all the jobs which are expired how can i do that?

How do you know if they are expired?

Through expired date

why am i not totally surprised

The where condition I posted gives you all rows with expiration date >= current date, which should be what you want?
If your current query is showing the rows with expiration date <= current date, then change the operator from < to >