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"
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.