MySQL Forums
Forum List  »  Full-Text Search

Boolean search with special characters
Posted by: arot
Date: June 22, 2005 03:37AM


I am trying to setup a simple boolean search as follows:

select * from table1 where match(column1, colum2) against ('$keyword' in boolean mode)

The problem: words with special characters are not found.

Table sample (table1):

colum1 column2
dat-001 Data 001 description...
dat-002 Data 002 description...

How could I perform a query to find exactly "dat-001" so the hyphen is not treated as boolean modifier?


Options: ReplyQuote

Written By
Boolean search with special characters
June 22, 2005 03:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.