MySQL :: MySQL 8.0 Reference Manual :: 10.2.1.2 Range Optimization

Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions

[k0kubun]

“ If the operator is >, <, >=, <=, !=, <>, BETWEEN, or LIKE, the optimizer uses it but considers no more key parts.”