02-09-2008, 03:53 PM
|
#1 (permalink)
|
|
The Acquainted
Join Date: Sep 2007
Posts: 133
Thanks: 6
|
MySQL5 Fulltext
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! |
|
|
Join the friendly bunch on IRC...
Threaded Mode
