-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
me time telling me regexp in the order by clause won't work.
I won't waste any more time down that road.
Thank you again,
-Emily
-Original Message-
From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 11:29 AM
To: Jim Lyons; mysql@lists.mysql.com; Emily Heureux
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.