RE: Order By and Ignore Punctuation

-+ | Olathe | | O'Malley | | Osbourn | | O'shea | | Ottawa | +--+ 5 rows in set (0.00 sec) -Original Message- From: Andreas Iwanowski [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 7:48 PM To: Bill Guion Cc: mysql@lists.mysql.com Subject: RE: Order By and Ig

RE: Order By and Ignore Punctuation

R BY Score; Hope to help, -Andy -Original Message- From: Bill Guion [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 8:33 PM To: mysql@lists.mysql.com Subject: Order By and Ignore Punctuation I would like to perform a query of a personnel database with an ORDER BY clause th

Re: Order By and Ignore Punctuation

Hi, Bill Guion wrote: I would like to perform a query of a personnel database with an ORDER BY clause that ignores punctuation. For example, O'shea would sort after Osbourne, not to the beginning of the Os. Is this doable in the query? If you only have a limited number of punctuation charac

Order By and Ignore Punctuation

I would like to perform a query of a personnel database with an ORDER BY clause that ignores punctuation. For example, O'shea would sort after Osbourne, not to the beginning of the Os. Is this doable in the query? -= Bill =- -- You can tell a lot about a man by the way he