rendered paste body| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| regions | 0 | PRIMARY | 1 | id | A | 26909 | NULL | | | BTREE | |
| regions | 1 | search_index | 1 | region | | 1 | NULL | | | FULLTEXT | |
| regions | 1 | search_index | 2 | town | | 1 | NULL | | | FULLTEXT | |
| regions | 1 | search_index | 3 | county | | 1 | NULL | | | FULLTEXT | |
+---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+