how to get the int order sorting asc, the order field already in varchar type
Posted
by karthikeyan1211
on Stack Overflow
See other posts from Stack Overflow
or by karthikeyan1211
Published on 2010-04-15T11:30:52Z
Indexed on
2010/04/15
11:33 UTC
Read the original article
Hit count: 431
mysql
I have the field receiptno as varchar and want to sort this, if normal order sorting getting wrong sorting value. Then have the idea to sort the field by convert int type. Is there anyway to converting int type in query itself
© Stack Overflow or respective owner