What is FULTEXT for purpose of natural-language searching

Databases
1

Hello,

We want to do search of certain fields in our DB, these fields are VARCHAR.
I see from MySQL that natural-language searching is possible with command like:

SELECT * FROM submit_web_data WHERE MATCH (title, descpt) AGAINST (‘hotels in Paris’);

But the MySQL gives error that: Can’t find FULLTEXT index matching the column list

Looking at MySQL manual I see this:

mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> ) ENGINE=MyISAM;
Query OK, 0 rows affected (0.00 sec)

so are we supposed to create a new field in our Table called:

FULLTEXT (title, descpt) ???

If yes, how does one create this new field?
And will this field data will then be auto filled from the moment it is added?

ThanX.

2

just like that

yes

3

Hello,

What do you mean just like that?
That is the Table in question currently does not have a FULLTEXT field.
So how do we add a FULLTEXT field to it made up of fields: title, body ?

ThanX

4

Hi.

Just wanted to let you know that I already got the answer to this question.
Thanks.