Hacker Noon

How MySQL Implicit Type Conversion Turned an Indexed Query Into a 7M-Row Scan | HackerNoon

A missing quote made MySQL scan 7.2 million rows. Here’s how EXPLAIN exposed the problem and what it taught us about safe production updates.