text: DROP TABLE articles;
  
  CREATE TABLE articles (
    id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    title VARCHAR(200),
    body TEXT,
    FULLTEXT (title, body)
  ); -- ENGINE=MyISAM for v5.5
  
  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 ...');
  
  SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
  +----+-------------------+------------------------------------------+
  | id | title             | body                                     |
  +----+-------------------+------------------------------------------+
  |  1 | MySQL Tutorial    | DBMS stands for DataBase ...             |
  |  5 | MySQL vs. YourSQL | In the following database comparison ... |
  +----+-------------------+------------------------------------------+
  
  SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('databas*' IN BOOLEAN MODE);
  +----+-------------------+------------------------------------------+
  | id | title             | body                                     |
  +----+-------------------+------------------------------------------+
  |  1 | MySQL Tutorial    | DBMS stands for DataBase ...             |
  |  5 | MySQL vs. YourSQL | In the following database comparison ... |
  +----+-------------------+------------------------------------------+
  
  SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('dat*base' IN BOOLEAN MODE);
  +----+-------------------+------------------------------------------+
  | id | title             | body                                     |
  +----+-------------------+------------------------------------------+
  |  1 | MySQL Tutorial    | DBMS stands for DataBase ...             |
  |  5 | MySQL vs. YourSQL | In the following database comparison ... |
  +----+-------------------+------------------------------------------+
  
  SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('*atabase' IN BOOLEAN MODE);
  Empty set (0.00 sec)
  