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