full text search select only matched colums
Hello,
i have a table with some text columns and a fulltext index for that columns.
Now i need to select only the matched colums.
So, when col1="aaa" and col2="bbb" and col3="ccc" and my tofind text="bbb", i need the information in which column the text was matched.
here, my select query:
SELECT * FROM table1 WHERE MATCH(`col1`,`col2`,`col3`) AGAINST('tofind*' IN BOOLEAN MODE);
is it possible anyway?
usher99
Edited 1 time(s). Last edit at 11/29/2011 05:13PM by usher mueller.
Subject
Views
Written By
Posted
full text search select only matched colums
2529
November 29, 2011 05:11PM
1231
December 02, 2011 07:49PM
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.