There are several strings that can convert to the given value. Added to that is the fact that MySQL will convert any string that doesn't start with a numeric value to 0. So MySQL cannot use index when comparing a string column with a number. This is explained in MySQL documentation.