List:General Discussion« Previous MessageNext Message »
From:Andreas Iwanowski Date:May 4 2007 2:48am
Subject:RE: Order By and Ignore Punctuation
View as plain text  
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:bguion@stripped] 
Sent: Thursday, May 03, 2007 8:33 PM
To: mysql@stripped
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/mysql?unsub=1



Thread
Order By and Ignore PunctuationBill Guion4 May
  • Re: Order By and Ignore PunctuationBaron Schwartz4 May
RE: Order By and Ignore PunctuationAndreas Iwanowski4 May
  • RE: Order By and Ignore PunctuationGordon4 May