Jump to content

Archived

This topic is now archived and is closed to further replies.

raymondrna

fulltext index matching .. not working.

Recommended Posts

[code]

show index from vinyl;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2986025
Current database: records

+-------+------------+------------+--------------+-------------+-----------+-----                 --------+----------+--------+----------+
| Table | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Card                 inality | Sub_part | Packed | Comment  |
+-------+------------+------------+--------------+-------------+-----------+-----                 --------+----------+--------+----------+
| vinyl |          0 | PRIMARY    |            1 | catalog     | A         |                            1 |     NULL | NULL   |          |
| vinyl |          1 | full_index |            1 | label       | A         |                         NULL |     NULL | NULL   | FULLTEXT |
| vinyl |          1 | full_index |            2 | title       | A         |                         NULL |     NULL | NULL   | FULLTEXT |
| vinyl |          1 | full_index |            3 | composer    | A         |                         NULL |     NULL | NULL   | FULLTEXT |
| vinyl |          1 | full_index |            4 | conducter   | A         |                         NULL |     NULL | NULL   | FULLTEXT |
| vinyl |          1 | full_index |            5 | performer   | A         |                         NULL |     NULL | NULL   | FULLTEXT |
+-------+------------+------------+--------------+-------------+-----------+-----                 --------+----------+--------+----------+
6 rows in set (0.01 sec)

mysql> select * from vinyl
    -> where match (title) against ('Symphony');
ERROR:

mysql>
mysql> select * from vinyl
    -> where match (title) against ('Symphony');
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2986047
Current database: records

ERROR 1191: Can't find FULLTEXT index matching the column list
mysql>
[/code]

what's going on?

I ask mysql to describe the index and it tells me it's there. Do a match, and match tells me it's not?

I'm guessing this is a simple syntax mistake, but I'm new with mysql and it seems like what I'm going should just work.

:P

Thanks for the help and your infinite wisdom!!

Share this post


Link to post
Share on other sites
That is indeed quite strange... should be just fine; post your SHOW CREATE TABLE output here, and I'll try it on my end.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.