Fulltext Search

[eugene2009]

Can somebody please help me find a good working script for creating the

 

MySql Fulltext search function?

 

I need the whole script and instructions how to create an index, and everything to make it work.

 

I searched all over google and cant find it. Please help, thank you.

[emopoops]

ALTER TABLE cities ADD city_soundex VARCHAR(4) NOT NULL;

UPDATE cities SET city_soundex=LEFT(SOUNDEX(city_name),4);

 

[fenway]

ALTER TABLE cities ADD city_soundex VARCHAR(4) NOT NULL;

UPDATE cities SET city_soundex=LEFT(SOUNDEX(city_name),4);

 

This has nothing to do with FULLTEXT.

[emopoops]

yes it does i found it on the fulltext manual page. dont be so quikc to judge

[Adam]

It was from a user comment:

 

An easy solution to correct for spelling errors for small search items like the name of the city is to build a column that contains the SOUNDEX of each. I've found that using a 4 character SOUNDEX works the best. An example:

 

ALTER TABLE cities ADD city_soundex VARCHAR(4) NOT NULL;

UPDATE cities SET city_soundex=LEFT(SOUNDEX(city_name),4);

[emopoops]

well. in my mind, it was my own comment

[fenway]

yes it does i found it on the fulltext manual page. dont be so quikc to judge

So what?