MySQL Forums
Forum List  »  Full-Text Search

Parameterized Full Text Search Problem
Posted by: Marc Taillieu
Date: November 21, 2007 05:20PM

I have run into a problem with full text search. I'm trying to perform a full-text search using a column from the table as the full-text criteria for a select on another table. I hope I'm explaining it well.

Select *, (select count(*) from table2 where match (table2.column1) against (concat('+',replace(table1.column1,' ',' +')) in boolean mode)) from table1;

The error I get is 'Incorrect arguments to AGAINST'

this is a simplified version of what I'm doing but it gets the point across. I've been trying to find any information regarding whether this is allowed or not but have yet to find anything. I hope somebody might be able to shed some light on this.

If anyone could help me it would be greatly appreciated.

Options: ReplyQuote

Written By
Parameterized Full Text Search Problem
November 21, 2007 05:20PM

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.