| 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   |         |
+---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+