mysql> explain SELECT COUNT(*) FROM vehicle_prod WHERE fin LIKE '%00000';
+----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
| 1 | SIMPLE | vehicle_prod | NULL | index | NULL | idx_vehicle_prod_fin | 203 | NULL | 3182812 | 11.11 | Using where; Using index |
+----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
1 row in set, 1 warning (0.00 sec)
