Re: order by "version number"

On Fri, 29 Apr 2005 08:20:58 +0200, Stano Paska <[EMAIL PROTECTED]> 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

RE: order by "version number"

To: mysql@lists.mysql.com Subject: order by "version number" 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. -- Stanislav Paška programátor, ww

Re: order by "version number"

Hi Stano, there was a response by Michael Stassen on the list about a year ago on this problem, which I hope he doesn't mind if I repeat below. /Johan Version numbers? CREATE TABLE ss (version VARCHAR(13)); INSERT INTO ss VALUES ('1'),('1.1'),('1.2.1.2'),('1.10.1'),('1.2'),

order by "version number"

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. -- Stanislav PaÅka programÃtor, www skupina KIOS s.r.o. tel: 033 / 794 00 18 -- MySQL General Mailing List