-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 8:25 PM
To: mysql@lists.mysql.com
Subject: natural sort via substrings
Hi, I am attempting to do a natural sort from within mysql, if
possible.
So, for example, jane2 would come before
-Original Message-
From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:33 AM
To: Emily Heureux; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
---8--- snip
Forgive me if I am incorrect, but wouldn't jane2 already be listed
before jane10
-Original Message-
From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 8:33 AM
To: Emily Heureux; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 11:12 AM
To: Boyd, Todd M.; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
Hi, I am sorry for being so vague. The values are not as simple as
jane20,
jane10, or jane2
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 8:25 PM
To: mysql@lists.mysql.com
Subject: natural sort via substrings
Hi, I am attempting to do a natural sort from within mysql, if
possible. So, for example, jane2 would come before
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an alphanumeric
field and a numeric field so:
jane-2 jane- 2
alex 3 alex 3
Subject: RE: natural sort via substrings
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an
alphanumeric field and a numeric field so