pweN9ELW

1CREATE TABLE IF NOT EXISTS metadata (
2    id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
3    title varchar(500),
4    category varchar(50),
5    uuid varchar(20),
6    FULLTEXT(title, category)
7) ENGINE=InnoDB;
8	
9mysql> explain SELECT uuid, title, category, MATCH(title, category) AGAINST ('grimm' IN NATURAL LANGUAGE MODE) AS score FROM metadata HAVING score > 0 limit 20;
10+----+-------------+----------+------------+------+---------------+------+---------+------+---------+----------+-------+
11| id | select_type | table    | partitions | type | possible_keys | key  | key_len | ref  | rows    | filtered | Extra |
12+----+-------------+----------+------------+------+---------------+------+---------+------+---------+----------+-------+
13|  1 | SIMPLE      | metadata | NULL       | ALL  | NULL          | NULL | NULL    | NULL | 1036202 |   100.00 | NULL  |
14+----+-------------+----------+------------+------+---------------+------+---------+------+---------+----------+-------+