Changes between Version 2 and Version 3 of FulltextSearchIdeas


Ignore:
Timestamp:
06/17/05 16:41:59 (19 years ago)
Author:
lauer
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • FulltextSearchIdeas

    v2 v3  
    22 
    33e.g. 
     4{{{ 
    45mysql> CREATE TABLE articles ( 
    56    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
     
    89    ->   FULLTEXT (title,body) 
    910    -> ); 
     11}}} 
    1012 
    1113example query: 
     14{{{ 
    1215mysql> SELECT * FROM articles 
    1316    -> WHERE MATCH (title,body) AGAINST ('database'); 
    14  
     17}}} 
    1518 
    1619Hints from MySQL documentation: