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?
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 ?
Just wanted to let you know that I already got the answer to this question.