Hi mates,
I'm running through a minor problem querying MySQL.
In a table it contains a field names 'location' and have data like below:
"location"
"Adamsville_AL"
"Adger_AL"
"Alabaster_AL"
"Alexander City_AL"
"Alexander City_AL"
"Allgood_AL"
"Alpine_AL"
"Arab_AL"
"Baileyton_AL"
"Bessemer_AL"
When I'm querying like this:
SELECT location FROM loc LIMIT 10
it gives me the data as above, the correct one, but when I'm changing the query like this:
SELECT latitude,longitude,location,summary FROM loc ORDER BY location DESC LIMIT 30;
it gives me the output like below:
"latitude" "longitude" "location" "summary"
"48.1328" "-117.74" "_WA" "Test Summary"
"43.7952" "-72.4001" "_VT" "Test Summary"
"39.0129" "-77.3956" "_VA" "Test Summary"
"38.9633" "-77.4587" "_VA" "Test Summary"
"39.0062" "-77.4288" "_VA" "Test Summary"
"37.4074" "-113.626" "_UT" "Test Summary"
"31.6965" "-94.1923" "_TX" "Test Summary"
"31.7715" "-97.1144" "_TX" "Test Summary"
"42.0539" "-77.4243" "_NY" "Test Summary"
"37.111" "-115.189" "_NV" "Test Summary"
I'm just unable to figure out what's wrong is going behind the scene. Please help if you've ever gone through such a slight problem. I appreciate any little help.
Best Regards
Sunny