SELECT . ORDER BY FIELD(month,'JAN','FEB','MAR',...,'NOV','DEC') .will order query output from a legacy table in month-number order.
Last updated 22 May 2024
The MySQL FIELD(str,str1,str2,...,strN) function returns 1 if str=str1, 2 if str=str2, etc., so ...
SELECT . ORDER BY FIELD(month,'JAN','FEB','MAR',...,'NOV','DEC') .will order query output from a legacy table in month-number order. Last updated 22 May 2024 |
|