Member Avatar for Horst Azeglio

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

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

or

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

When I put two arguments:

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

  • 2 Contributors
  • 1 Reply
  • 111 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Dani

Do you actually have a single fulltext index of both columns together?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.