> -----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" if you just ORDER BY <fieldname> ASC? I suppose "jane2" Man, what a morning. After reading what I wrote, it's obvious to me that this should not happen (jane2 coming before jane10, I mean.. 1 < 2). Maybe sort by length first, then sub-sort by alpha? As far as regex goes, I know of no way to use it inside the MySQL function substring_index(). Todd Boyd Web Programmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]