ysql@lists.mysql.com; Emily Heureux
> 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 fr
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
> -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
> possi
> -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
&
R BY.
Thanks,
Emily
> -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
> -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 "ja
> -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
> possib
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 s
Oh, and here's the output (Sorry):
+---+-+
| releaseid | name|
+---+-+
| 1 | Unspecified |
| 2 | Next Patch |
| 3 | LOCset |
| 4 | Abashiri|
|
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' ),
(
> -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
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 | Unspecifie
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
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 c
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?
>
> 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
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
> >
> >o
17 matches
Mail list logo
