alpha numeric sorting using mysql query
I have several product ids. Here are some examples:
c-05开发者_高级运维 , C-1025 , C-1035 , C-155 , C1B , k-1202
I have to sort these ones in ascending order.
I've tried with an ORDER BY
clause with ascendent direction, but doesn't achieve what I need.
Any proposal?
精彩评论