Please explain, which one will be faster in Mysql for the following query?
SELECT * FROM `userstatus` where BINARY Name = 'Raja'
SELECT * FROM `userstatus` where Name = 'raja'
Db entry for Name field is 'Raja' there is no key for the field.
I have 1000000 records in my db, i tried with "explain" query but both saying same execution time.