MySQL Forums
Forum List  »  MyISAM

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

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
full text search select only matched colums
2528
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.