Query returns the substring after underscore for a location field

See more:

MySQL

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