Boolean search with special characters
Posted by:
arot
Date: June 22, 2005 03:37AM
Hello,
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?
Thanks!
Subject
Views
Written By
Posted
Boolean search with special characters
4020
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.