Can anyone please help me to understand the MySQL select query behavior,
Table Structure:
CREATE TABLE `dummytable` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mobile` int(11) NOT NULL,
`welcome` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Question: Why I am getting this result?
SELECT * FROM `dummytable` WHERE `mobile` = '\'\'' LIMIT 50
where mobile = ''
makes no sense at all. An integer can not contain an (empty) string. Other DBMS would simply reject to compare apples with oranges.