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... Link to comment https://forums.phpfreaks.com/topic/109359-solved-sorting-in-mysql/ Share on other sites More sharing options...
sasa Posted June 9, 2008 Share Posted June 9, 2008 ORDER BY substring(prod_id,2)+0 Link to comment https://forums.phpfreaks.com/topic/109359-solved-sorting-in-mysql/#findComment-560924 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. Link to comment https://forums.phpfreaks.com/topic/109359-solved-sorting-in-mysql/#findComment-560925 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 Link to comment https://forums.phpfreaks.com/topic/109359-solved-sorting-in-mysql/#findComment-560927 Share on other sites More sharing options...
mmarif4u Posted June 9, 2008 Author Share Posted June 9, 2008 ok. thanks Link to comment https://forums.phpfreaks.com/topic/109359-solved-sorting-in-mysql/#findComment-560929 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.