-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
Hi, I am attempting to do a natural sort from within mysql, if possible.
So, for example, jane2 would come before jane10, and normal strings would
still sort as expected. I found some solutions, like using length for the
numerical part, but that only works if the strings are the same length
I'm trying to get some 'release/version numbers' to sort properly.
mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 | Unspecified |
|20
Daevid Vincent wrote:
I'm trying to get some 'release/version numbers' to sort properly.
mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 |
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Friday, October 12, 2007 2:07 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Need help with a natural sort order for
version numbers and release code names
Daevid Vincent wrote:
I'm trying
Here's my full test solution:
use test;
drop table if exists releases;
create temporary table releases
(
releaseid int(10) unsigned not null auto_increment primary key,
name varchar(255)
)engine=myisam;
insert into releases ( name ) values
( 'Unspecified' ),
( 'Next Patch' ),
(
Oh, and here's the output (Sorry):
+---+-+
| releaseid | name|
+---+-+
| 1 | Unspecified |
| 2 | Next Patch |
| 3 | LOCset |
| 4 | Abashiri|
|
Looking thru the MYSQL archives I see a few people had interest in a natural
sort method to sort text fields
containing numbers. I to would like this feature. Has anything been
done for this?
Currently sorts text like:
1200 - A tale of 3 dogs
3 bright lights go on
Should be:
3
In the last episode (Nov 12), Michael Kedl said:
Looking thru the MYSQL archives I see a few people had interest in
a natural sort method to sort text fields containing numbers. I
to would like this feature. Has anything been done for this?
Currently sorts text like:
1200 - A tale
In the last episode (Nov 12), Michael Kedl said:
Dan Nelson wrote:
In the last episode (Nov 12), Michael Kedl said:
Looking thru the MYSQL archives I see a few people had interest
in a natural sort method to sort text fields containing
numbers. I to would like this feature. Has
How many people would be interested in this feature?
On Wed, Jun 27, 2001 at 01:46:05PM +0300, [EMAIL PROTECTED] wrote:
Brannon King wrote:
Any plans for a natural sort? A query to the effect of
ORDER BY [~] NATURAL ASC
or
ORDER BY [~] NATASC
etc.
That would
17 matches
Mail list logo