In Mysql,I write the following query:
select * from emp where designation = "MANAGER"
But the actual value in the table is "manager"
Will the above query retrieve any records?
According to me it should not.But I am getting all records for which designation is "manager".
Please guide why it is happening and help me with this so that I get records nly if the where condition is "manager" and not "MANAGER"