Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sorting a column
SELECT col FROM foo ORDER BY col REGEXP "^[^0-9]", col+0, col This query works while sorting in ascending order While SELECT col FROM foo ORDER BY col REGEXP "^[^0-9]", col+0, col DESC doesnt works :( -
-
-
Sorting a column
Hi I have the following query select SUBSTRING_INDEX(m.FileName, '/', -1) as ShortFileName from modifications m order by ShortFileName ASC; The output of the query is +------------------------+ | ShortFileName | +------------------------+ | CTKAction.java | | CTKView.java... -
Sorting a column
Hi I have a varchar column say Issue with data as follow 900 1100 update test 800 Now I want to sort this column but the sort by query sorts it like 1100 800 900 test update Can anyone tell me the correct way to sot this column
