如何使用大于sql中当前日期的数据进行过滤？

filter data which is greater than current date

select * from event_participant where username='$username' AND event_date>=GETDATE()

I have been try this query but seems doesn't works

Try using CURDATE() instead of GETDATE():

SELECT *
FROM event_participant
WHERE username = '$username'
    AND event_date >= CURDATE()

Mysql: NOW(), CURDATE()

SQL Server: GETDATE()