Hi, I am new to the list :)
Have a question, I have not been able to find any information on this on the
MySQL site.
Is it possible to sort a varchar field that contains numbers as an integer
field?
ie. right now it is sorting 1,2,4,10,11,12 as:
1
10
11
2
4
I would like to see it properly
SELECT ... FROM tablename ORDER BY varcharcolumn+0;
Gurhan
-Original Message-
From: Maksim Rogov [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: Sorting a varchar field...
Hi, I am new to the list :)
Have a question, I have not been able
hi again,
Now I need to sort a field of varchar type. But the filed values are like...
b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12
meaning thereby, an integer prefixed by some character.
Is there any straight way to frame the query?
thanx in advance for your time,
regards,
-vishi
On Tue, 2002-02-05 at 10:18, Vishakha Mali_Wagh wrote:
Now I need to sort a field of varchar type. But the filed values are like...
b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12
meaning thereby, an integer prefixed by some character.
Is there any straight way to frame the query?
OK, if the