Mega Code Archive

 

Categories / MySQL / Function

 

SELECT IF(02-29 03-01,02-29,03-01) AS earliest

mysql> mysql> mysql> SELECT IF('02-29' < '03-01','02-29','03-01') AS earliest; +----------+ | earliest | +----------+ | 02-29    | +----------+ 1 row in set (0.00 sec) mysql>