1  
   2  EXPLAIN SELECT ... WHERE ...

   1  
   2  mysql> CREATE TABLE articles (
   3      ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
   4      ->   title VARCHAR(200),
   5      ->   body TEXT,
   6      ->   FULLTEXT (title,body)
   7      -> );
   8  Query OK, 0 rows affected (0.00 sec)
   9  
  10  mysql> INSERT INTO articles (title,body) VALUES
  11      -> ('MySQL Tutorial','DBMS stands for DataBase ...'),
  12      -> ('How To Use MySQL Well','After you went through a ...'),
  13      -> ('Optimizing MySQL','In this tutorial we will show ...'),
  14      -> ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
  15      -> ('MySQL vs. YourSQL','In the following database comparison ...'),
  16      -> ('MySQL Security','When configured properly, MySQL ...');
  17  Query OK, 6 rows affected (0.00 sec)
  18  Records: 6  Duplicates: 0  Warnings: 0
  19  
  20  mysql> SELECT * FROM articles
  21      -> WHERE MATCH (title,body) AGAINST ('database');
  22  +----+-------------------+------------------------------------------+
  23  | id | title             | body                                     |
  24  +----+-------------------+------------------------------------------+
  25  |  5 | MySQL vs. YourSQL | In the following database comparison ... |
  26  |  1 | MySQL Tutorial    | DBMS stands for DataBase ...             |
  27  +----+-------------------+------------------------------------------+
  28  2 rows in set (0.00 sec)