Right now I have this as my mysql query:
SELECT * FROM rofl WHERE id='13159' LIMIT 1
This returns the correct table. My question is though if I add a letter to it like this:
SELECT * FROM rofl WHERE id='13159f' LIMIT 1
Why does it still return the row with the column id 13159? Its like it is ignoring the "f" and still returning the row as if it wasn't there.
If I take out all the numbers and just have it as "f" it says there is no row.
If I take out the "f" and replace it with a "5" or something, it also says there is no row.
Any ideas on why numbers + letters are acting this way in the WHERE clause, and how I should fix it?
Thanks in advance for any help!