CREATE TABLE `a` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`f1` varchar(255) DEFAULT NULL,
`f2` varchar(255) DEFAULT NULL,
`f3` varchar(255) DEFAULT NULL,
`f4` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
SELECT * FROM a
WHERE
f1 IS NOT NULL
AND f1 !=''
AND
(f2 IS NULL OR f2 ='' )
AND
(f3 IS NULL OR f3 ='' )