mysql - MySQL Where Date is greater than today

Question

I try to get every record from my MySQL database which is greater than today.

SELECT `contract_to`
     , CURDATE() 
  FROM `contacts` 
 WHERE `contract_to` > 'CURDATE()'

Actual Result I expected
contract_to  |  CURDATE()
2021-03-27   |  2019-03-30

but I got the following

contract_to  |  CURDATE()
2019-03-20   |  2019-03-30
2021-03-27   |  2019-03-30

标签： mysql

Answer 1

SELECT contract_to FROM contacts WHERE contract_to > CURDATE();