ORDER BY in Union
View Single Post
06-03-2013, 10:40 PM
Supreme Master coder!
Join Date: Feb 2009
Thanked 4,307 Times in 4,274 Posts
You don't have to change it. You can just convert it in the ORDER BY.
... ORDER BY CAST( G.the_location AS UNSIGNED )
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
View Public Profile
Find More Posts by Old Pedant