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?