e field for display
> purposes.
>
> If your table is of any size whatsoever this would be vastly preferable to
> doing all sorts of substring-ing in your where clauses. You won't have a
> prayer of having the optimizer use an index.
>
> Jim
>
> On Fri, Jun 13,
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
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.
Ide
