Fulltext Mysql Version 3.23.12

rosieraz

I was wondering whether anyone could help. I want to create a fulltext index on some fields on my table but can't get the fulltext function to work on MySql.

Is this due to the version that I am running? If so is there any way of me creating a fulltext on this version of MySql.

Heres the command that I have been trying so far:

ALTER TABLE TableName
ADD FULLTEXT (company, description);

Any ideas?? I would really appreciate any help that you could give me.

Anon

Rosanna,

Looking at the change history for MySql, fulltext indexing was only introduced in 3.23.23

Unfortunately without a significant amount of coding to generate your own indicies, there's no easy way around it (bar getting a MySql update done on the server).

Justin

[deleted]

The article 'slapping together a search engine' should give ample info on how to create your own searchengine. It even has working examples of how to do it.

MySQL's fulltext indexes are pretty useless in that they can only match on whole words.
The home-made version can search on partial words and still be very fast. The home made version can also be made to contain data from several tables at the same time.

A forum, a FAQ, what else do you need?