mysql 全文检索

手册上的内容：
MySQL   has   support   for   full-text   indexing   and   searching:  

A   full-text   index   in   MySQL   is   an   index   of   type   FULLTEXT.  

Full-text   indexes   can   be   used   only   with   MyISAM   tables,   and   can   be   created   only   for   CHAR,   VARCHAR,   or   TEXT   columns.  

A   FULLTEXT   index   definition   can   be   given   in   the   CREATE   TABLE   statement   when   a   table   is   created,   or   added   later   using   ALTER   TABLE   or   CREATE   INDEX.  

例子：

SQL code

   
   

    
    
    
    
mysql
    
    >
    
     
    
    CREATE
    
     
    
    TABLE
    
     articles (
    
    
    ->
    
       id 
    
    INT
    
     UNSIGNED AUTO_INCREMENT 
    
    NOT
    
     
    
    NULL
    
     
    
    PRIMARY
    
     
    
    KEY
    
    ,
    
    
    ->
    
       title 
    
    VARCHAR
    
    (
    
    200
    
    ),
    
    
    ->
    
       body 
    
    TEXT
    
    ,
    
    
    ->
    
       FULLTEXT (title,body)
    
    
    ->
    
     );
Query OK, 
    
    0
    
     rows affected (
    
    0.00
    
     sec)

mysql
    
    >
    
     
    
    INSERT
    
     
    
    INTO
    
     articles (title,body) 
    
    VALUES
    
    
    
    
    ->
    
     (
    
    '
    
    MySQL Tutorial
    
    '
    
    ,
    
    '
    
    DBMS stands for DataBase ...
    
    '
    
    ),
    
    
    ->
    
     (
    
    '
    
    How To Use MySQL Well
    
    '
    
    ,
    
    '
    
    After you went through a ...
    
    '
    
    ),
    
    
    ->
    
     (
    
    '
    
    Optimizing MySQL
    
    '
    
    ,
    
    '
    
    In this tutorial we will show ...
    
    '
    
    ),
    
    
    ->
    
     (
    
    '
    
    1001 MySQL Tricks
    
    '
    
    ,
    
    '
    
    1. Never run mysqld as root. 2. ...
    
    '
    
    ),
    
    
    ->
    
     (
    
    '
    
    MySQL vs. YourSQL
    
    '
    
    ,
    
    '
    
    In the following database comparison ...
    
    '
    
    ),
    
    
    ->
    
     (
    
    '
    
    MySQL Security
    
    '
    
    ,
    
    '
    
    When configured properly, MySQL ...
    
    '
    
    );
Query OK, 
    
    6
    
     rows affected (
    
    0.00
    
     sec)
Records: 
    
    6
    
      Duplicates: 
    
    0
    
      Warnings: 
    
    0
    
    

mysql
    
    >
    
     
    
    SELECT
    
     
    
    *
    
     
    
    FROM
    
     articles
    
    
    ->
    
     
    
    WHERE
    
     MATCH (title,body) AGAINST (
    
    '
    
    database
    
    '
    
    );

    
    +
    
    --
    
    --+-------------------+------------------------------------------+
    
    

    
    |
    
     id 
    
    |
    
     title             
    
    |
    
     body                                     
    
    |
    
    

    
    +
    
    --
    
    --+-------------------+------------------------------------------+
    
    

    
    |
    
      
    
    5
    
     
    
    |
    
     MySQL vs. YourSQL 
    
    |
    
     
    
    In
    
     the following 
    
    database
    
     comparison ... 
    
    |
    
    

    
    |
    
      
    
    1
    
     
    
    |
    
     MySQL Tutorial    
    
    |
    
     DBMS stands 
    
    for
    
     
    
    DataBase
    
     ...             
    
    |
    
    

    
    +
    
    --
    
    --+-------------------+------------------------------------------+
    
    

    
    2
    
     rows 
    
    in
    
     
    
    set
    
     (
    
    0.00
    
     sec)