Parameterized Full Text Search Problem

[Marc Taillieu]

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.