Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See Below )
mysql> show index from entries\g +---------+------------+-------------+--------------+---------------+------- ----+-------------+----------+--------+----------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---------+------------+-------------+--------------+---------------+------- ----+-------------+----------+--------+----------+ | entries | 1 | entries_idx | 1 | Entry | A | NULL | NULL | NULL | | | entries | 1 | entries_idx | 2 | EntryCountry | A | NULL | NULL | NULL | | | entries | 1 | Entry | 1 | Entry | A | NULL | 1 | NULL | FULLTEXT | | entries | 1 | Entry | 2 | EntryCountry | A | NULL | NULL | NULL | FULLTEXT | +---------+------------+-------------+--------------+---------------+------- ----+-------------+----------+--------+----------+ 8 rows in set (0.02 sec) ... but when I run a search I get: mysql> SELECT ID, MATCH ( Entry ) AGAINST ( 'peace corps' ) AS Score FROM entries WHERE MATCH ( Entry ) AGAINST ( 'peace corps' ) >0 AND UID != 'demo' HAVING Score >0 ORDER BY Score DESC\g ERROR 1191: Can't find FULLTEXT index matching the column list Why!?!?!?! Help! Luc --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
