CREATE TABLE my_table
(id INT AUTO_INCREMENT, name varchar(50) null, score decimal(6,2), datestamp date, PRIMARY KEY (id) )
;
INSERT INTO my_table
(id, name, score, datestamp)
values
(1, 'abc', 10 , '2015-01-06 00:00:00') ,
(2, '', 20 , '2015-01-12 00:00:00') ,
(3, NULL, 30 , '2015-01-10 00:00:00');
SELECT * FROM `my_table` WHERE `name` IS NULL;
Q1JFQVRFIFRBQkxFIG15X3RhYmxlCihpZCBJTlQgQVVUT19JTkNSRU1FTlQsIG5hbWUgdmFyY2hhcig1MCkgbnVsbCwgc2NvcmUgZGVjaW1hbCg2LDIpLCBkYXRlc3RhbXAgZGF0ZSwgUFJJTUFSWSBLRVkgKGlkKSApCjsKSU5TRVJUIElOVE8gbXlfdGFibGUKKGlkLCBuYW1lLCBzY29yZSwgZGF0ZXN0YW1wKQp2YWx1ZXMKKDEsICdhYmMnLAkxMAksCScyMDE1LTAxLTA2IDAwOjAwOjAwJykJLAooMiwgJycsCQkyMAksCScyMDE1LTAxLTEyIDAwOjAwOjAwJykJLAooMywgTlVMTCwJMzAJLAknMjAxNS0wMS0xMCAwMDowMDowMCcpOwpTRUxFQ1QgKiBGUk9NIGBteV90YWJsZWAgV0hFUkUgYG5hbWVgIElTIE5VTEw7