MySQL Forums
Forum List  »  MyISAM

full text search select only matched colums
Posted by: usher mueller
Date: November 29, 2011 05:11PM


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?


Edited 1 time(s). Last edit at 11/29/2011 05:13PM by usher mueller.

Options: ReplyQuote

Written By
full text search select only matched colums
November 29, 2011 05:11PM

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.