MySQL failed to select...help?
Posted on 2015-02-06
This is going to drive me nuts.
I can't seem to select a particular email address in mySQL database.
I have this simple :
SELECT * FROM `User` WHERE email = "email@example.com";
Which returns a value.
But not this :
SELECT * FROM `User` WHERE email = "firstname.lastname@example.org";
No error messages. Simply 0 result set. However, since the email address is top in the database, i know it exists. I am staring at it.
What could possibly be a common mistake I am doing?