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.