It even has a name - SARGable - able to use an index on the [S]earch [ARG]uments but still easy to get tripped up.

https://www.definitions.net/definition/sargable

https://stackoverflow.com/questions/799584/what-makes-a-sql-...