How can I put (IF)condition in my SQL code?

Question

I need to put (IF) condition in my code to show only the datediff bigger than 0 but always happen error , anybody can help me please ?

SELECT DATEDIFF(`Date` ,CURDATE()) AS Date,`id` AS Dateid
FROM `election`
ORDER BY `Date` ASC

i need only Date bigger than 0

@jarlh dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html ? Though the rest of the comment seems right on. — Jonnix
– Jonnix, Commented Nov 17, 2016 at 13:29
@jarlh how ? can u fix it for me i need to show datediff bigger than 0 — Mohamd El-Saleh
– Mohamd El-Saleh, Commented Nov 17, 2016 at 13:30
@jarlh you sure about that? dev.mysql.com/doc/refman/5.7/en/if.html — Takarii
– Takarii, Commented Nov 17, 2016 at 13:30

Will · Accepted Answer · 2016-11-17 13:57:44Z

1

Not very pretty, but you can just recreate the date field in the where clause to compare it:

SELECT DATEDIFF(`Date` ,CURDATE()) AS Date,`id` AS Dateid
FROM `election`
WHERE DATEDIFF(`Date` ,CURDATE()) > 0
ORDER BY `Date` ASC

answered Nov 17, 2016 at 13:57

Will

4,4696 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I wouldn't worry about how pretty it looks if it does the job!