I would suggest you order by something that includes a fulltext index on the specific column. Maybe check out the documentation on the MATCH()AGAINST() systax as well as fulltext searches in general.
For example: SELECT Col1, Col2, Score AS MATCH(TextCol) AGAINST ("") WHERE ... ORDER 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 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 handles these three things: a rainy day, lost luggage, and tangled Christmas tree lights. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]