Changes between Version 2 and Version 3 of FulltextSearchIdeas
- Timestamp:
- 06/17/05 16:41:59 (19 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
FulltextSearchIdeas
v2 v3 2 2 3 3 e.g. 4 {{{ 4 5 mysql> CREATE TABLE articles ( 5 6 -> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, … … 8 9 -> FULLTEXT (title,body) 9 10 -> ); 11 }}} 10 12 11 13 example query: 14 {{{ 12 15 mysql> SELECT * FROM articles 13 16 -> WHERE MATCH (title,body) AGAINST ('database'); 14 17 }}} 15 18 16 19 Hints from MySQL documentation: