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 1 text column into 3 integer columns? SELECT * FROM table ORDER BY MajorVersion, MinorVersion, Release
Dusan
-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
