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
> possible. So, for example, jane2 would come
> -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
> possible.
> So, for example, jane2 would co
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
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:
> > 12
