mysql> show create table film_text\G

*************************** 1. row ***************************

       Table: film_text

Create Table: CREATE TABLE `film_text` (

  `film_id` smallint(6) NOT NULL,

  `title` varchar(255) NOT NULL,

  `description` text,

  FULLTEXT KEY `idx_title_description` (`title`,`description`),

  FULLTEXT KEY `idx_title` (`title`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

mysql> select title as "Title" from film_text where match(title) against ('ACADEMY' in natural language mode);

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

| Title            |

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

| ACADEMY DINOSAUR |

| VICTORY ACADEMY  |

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