Strict Matching For Selects

[patkins2474]

All,

Someone please explain why this would match and return a row. I'm not using WHERE id LIKE '%297%' or something that you would expect this type of response.

mysql> SELECT id, fullname, firstname, lastname, createdate FROM test WHERE id='297asd';
+-----+-------+-----------+----------+------------+
| id | bname | firstname | lastname | createdate |
+-----+-------+-----------+----------+------------+
| 297 | , | NULL | NULL | 20040830 |
+-----+-------+-----------+----------+------------+
1 row in set (0.00 sec)