mmarif4u Posted June 9, 2008 Share Posted June 9, 2008 I want to sort my one db table column by asc or desc. For example it have values: P117E P117E P117E P121E P122E P122E P123E P123E P79E P79E P79E P79E P79E These are sorted by order,and is asc. Query will look like: "select * from table order by prod_id asc" suppose that P123E have to be the 1st value in this case. I know that mysql is sorting it like: 11 111 123 233 33 35 37 4 but i want to sort it by max and min values not by 1 then 2 and 3. something like: P123E P123E P122E P122E P121E P117E P117E P117E P79E P79E P79E P79E P79E and vice versa. Any ideas... Quote Link to comment Share on other sites More sharing options...
sasa Posted June 9, 2008 Share Posted June 9, 2008 ORDER BY substring(prod_id,2)+0 Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted June 9, 2008 Author Share Posted June 9, 2008 Thanks,it works great.while adding desc if need to be in desc order. substring(prod_id,2)+0 desc could u a bit explain what does +0 mean. Quote Link to comment Share on other sites More sharing options...
sasa Posted June 9, 2008 Share Posted June 9, 2008 +0 convert string to number you can use CONVERT() or CAST() function Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted June 9, 2008 Author Share Posted June 9, 2008 ok. thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.