Results 1 to 4 of 4
Nov 30, 2012, 23:15 #1
What is FULTEXT for purpose of natural-language searching
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?
Dec 1, 2012, 06:43 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 52 Post(s)
- 2 Thread(s)
Dec 1, 2012, 19:54 #3
Dec 1, 2012, 22:48 #4