On Monday 23 December 2002 04:20, luc2 wrote: > 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!?!?!?! Because you have FULLTEXT index on 2 columns - Entry and EntryCountry, but you make a search only on one of these column. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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