WHERE order_date = '2026/09/28' worked in the development environment, but resulted in a date conversion error in production.
A missing quote made MySQL scan 7.2 million rows. Here's how EXPLAIN exposed the problem and what it taught us about safe ...