set use_stat_tables='preferably';

set optimizer_use_condition_selectivity=3;

create table t1(col1 char(32));

insert into t1 values ('a'),('b'),('c'),('d'), ('e'),('f'),('g'),('h');

analyze table t1 persistent for columns () indexes ();

explain extended 

select * from t1 where col1 > 'b' and col1 < 'd';

MariaDB [test]> explain extended 

    -> select * from t1 where col1 > 'b' and col1 < 'e';

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

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra       |

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

|    1 | SIMPLE      | t1    | ALL  | NULL          | NULL | NULL    | NULL |    8 |     0.00 | Using where |

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