MySQL DATE_FORMAT function and ORDER BY

(Shahryar Ghazi) An interesting scenario that I came across today was the fact that if you use the same alias as the column name in a formatted string (using DATE_FORMAT) and you also use same alias in ORDER BY or GROUP BY clause then MySQL uses the string output of DATE_FORMAT to sort records rathe

Read More - Register for Free Membership