Select when where is Any record

select * from contacts where email Is Not Null

If not working try 

select * from contacts where email Is Not Null and email Is Null

Create Table

delimiter $$

CREATE TABLE `contacts` (

  `RowID` int(11) NOT NULL,

  `SuperCoreID` varchar(45) DEFAULT NULL,

  `SuperOrgName` varchar(100) DEFAULT NULL,

  `CoreID` varchar(45) DEFAULT NULL,

  `TranDept` varchar(45) DEFAULT NULL,

  `TranSubPractice` varchar(45) DEFAULT NULL,

  `OrgIssuer` varchar(100) DEFAULT NULL,

  `LAM` varchar(45) DEFAULT NULL,

  `ContactRole` varchar(45) DEFAULT NULL,

  `Contact Level` varchar(45) DEFAULT NULL,

  `Salutation` varchar(45) DEFAULT NULL,

  `FirstName` varchar(45) DEFAULT NULL,

  `MiddleName` varchar(45) DEFAULT NULL,

  `LastName` varchar(45) DEFAULT NULL,

  `CompanyName` varchar(45) DEFAULT NULL,

  `Address1` varchar(45) DEFAULT NULL,

  `Address2` varchar(45) DEFAULT NULL,

  `Address3` varchar(45) DEFAULT NULL,

  `City` varchar(45) DEFAULT NULL,

  `Postcode` varchar(45) DEFAULT NULL,

  `Country` varchar(45) DEFAULT NULL,

  `Email` varchar(45) DEFAULT NULL,

  `PhoneLand` varchar(45) DEFAULT NULL,

  `PhoneMob` varchar(45) DEFAULT NULL,

  `RoleInTran` varchar(45) DEFAULT NULL,

  `ComReqdInsiders` varchar(45) DEFAULT NULL,

  `ComReqdSov` varchar(45) DEFAULT NULL,

  `ComeReqdResec` varchar(45) DEFAULT NULL,

  PRIMARY KEY (`RowID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8$$

load csv data file into database

load data local infile 'C:/contact_csv2.csv'

into table TestSchema.TestTable fields terminated by ',' enclosed by '"'

lines terminated by '\n'

Where TestSchema is database, TestTable is table name, use '\n' if .csv file generated by PC, use '\r' if .csv file generated by Mac