FULLTEXT index help

Horst Azeglio · June 11th, 2006, 07:39 PM

I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26

When I put only one argument in MATCH, it shows no error but doesn't return anything

Quote:

quote:
SELECT * FROM item WHERE MATCH (nom) against ('Huile');

or

Quote:

quote:SELECT * FROM item WHERE MATCH (nom_en) against ('Huile');

When I put two arguments:

Quote:

quote:SELECT * FROM item WHERE MATCH (nom,nom_en) against ('Huile');

It says: "Can't find FULLTEXT index matching the column list", but both nom and nom_en are FULLTEXT indexed and the table "item" is MyISAM.

Anyone can help? thank you

jmaronilla · June 26th, 2006, 11:47 PM

Try:

a) SELECT *, MATCH (nom) AGAINST ('Huile') As nomHuile FROM item;

b) SELECT *, MATCH (nom_em) AGAINST ('Huile') As nom_emHuile FROM item;

c) SELECT *, MATCH (nom, nom_em) AGAINST ('Huile') As nom_nom_emHuile FROM item;

johnm