Using redundant conditions to unlock indexes in MySQL

MySQL can use indexes when queries avoid wrapping indexed columns in functions. Adding a redundant condition that mirrors the indexed column's raw value forces MySQL to use the index, improving query performance without changing the result.