MySQL Lists: mysql: Order by problem

List:	General Discussion	« Previous Message Next Message »
From:	Sagar C Nannapaneni	Date:	January 23 2004 12:49pm
Subject:	Order by problem
View as plain text

Hi all,

I have an ID field in my database...it reads like this

ASS1
ASS23
ASS4
ASS10
ASS6
.
.
.

when i'm retrieving the data by taking ORDER BY clause it is sorting like this

ASS1
ASS10
ASS23
ASS4
ASS6

means its only sorting by the 4 the character. i want the sorting to be done like the
following

ASS1
ASS4
ASS6
ASS10
ASS23

Solutions are greatly appreciated

thanks in adavance

/sagar

Thread
• Order by problem	Sagar C Nannapaneni	23 Jan
• Re: Order by problem	Martijn Tonies	23 Jan
• Re: Order by problem	Benoit St-Jean	23 Jan
• Re: Order by problem	Frederic Wenzel	23 Jan
• SELECT statement	Gary Broughton	23 Jan
• Re: Order by problem	mos	23 Jan
• Re: Order by problem	mos	23 Jan