Issue with exact match returning wrong results
We are having unexpected results from mysql, we are using following query...
SELECT * FROM `tbl.members` WHERE `referredby` LIKE '%MEM04912%';
and it returns correct results(5), but when we try exact match as
following...
SELECT * FROM `tbl.members` WHERE `referredby` = 'MEM04912';
We only get one results, but correct value is 5, can you help me resolve
the same.