mysql 与null比较大小_mysql – 与NULL值比较

CREATE TABLE `mycompare` (

`name` varchar(100) default NULL,

`fname` varchar(100) default NULL,

`mname` varchar(100) default NULL,

`lname` varchar(100) default NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `mycompare` VALUES('amar', 'ajay', 'shankar', NULL);

INSERT INTO `mycompare` VALUES('akbar', 'bhai', 'aslam', 'akbar');

INSERT INTO `mycompare` VALUES('anthony', 'john', 'Jim', 'Ken');

_____

SELECT * FROM mycompare WHERE (name = fname OR name = mname OR name = lname)

akbar bhai aslam akbar

select * from mycompare where !(name = fname OR name = mname OR name = lname)

anthony john Jim Ken

在上面的第二个选择中,我期望“amar”记录,因为该名称与First,second或lastname不匹配.