MYSQL select with 2 dates condition

Question

In my database, I have 2 different dates. A move date and a event date. I would like to run a query by event date. But if there is no event date, so i want use the move date. Is there a MYSQL code that does this? Like this: "where if .." Of course the result is in descending order date. Thanks !

Maybe coalesce something like where coalesce(eventdate, movedate) >= ? not a PHP question though — user3783243
– user3783243, Commented Mar 29, 2019 at 14:37

Ismail MANAREDDINE · Accepted Answer · 2019-03-29 14:41:31Z

1

try this one like where coalesce(event_date, move_date) >= ?

answered Mar 29, 2019 at 14:41

Ismail MANAREDDINE

997 bronze badges

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

1 Comment

Canta Over a year ago

Thanks a lot! I will try this.

luna80 · Accepted Answer · 2019-03-29 15:05:30Z

0

use the "case" condition

SELECT CASE WHEN movedate != NULL THEN movedate ELSE eventdate END AS selecteddate

answered Mar 29, 2019 at 15:05

luna80

1533 silver badges16 bronze badges

Collectives™ on Stack Overflow

MYSQL select with 2 dates condition

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related