TalkPHP - View Single Post

WinSrev · 02-09-2008, 03:53 PM

Hey,

Been trying to search through my database using fulltext, i used the query:

Code:

SELECT *
FROM `table1`
LEFT JOIN `table2` ON `table1`.`col1` = `table2`.`col2`
WHERE MATCH (
major1, major2
)
AGAINST (
'theory'
)
LIMIT 0 , 30

But the problem it gives an error:

Quote:

#1191 - Can't find FULLTEXT index matching the column list

although running each column seperatly works. Any ideas?

Thanks!