Re: order by "version number" - Dusan Kolesar - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: order by "version number"

From	Sent On	Attachments
Stano Paska	28 Apr 2005 23:20
Johan Höök	29 Apr 2005 00:12
mathias fatene	29 Apr 2005 00:18
Dusan Kolesar	29 Apr 2005 00:22

Subject:	Re: order by "version number"
From:	Dusan Kolesar (d.ko...@centrum.sk)
Date:	04/29/2005 12:22:23 AM
List:	com.mysql.lists.mysql

On Fri, 29 Apr 2005 08:20:58 +0200, Stano Paska <stan...@kios.sk> wrote:

Hi, in my table I have one varchar(20) column where I store version number. Version looks like: 1.1.2 1.2.1 1.10.3 It is possible order this column in natural order (1.2 before 1.10)? Stano.

Hello Stano, What about divide 1 text column into 3 integer columns? SELECT * FROM table ORDER BY MajorVersion, MinorVersion, Release

Dusan