SELECT name, address, city, state, zipcode, email, voicephone, spare1, spare2, spare3, lastname, firstname into outfile 'c:\\Loan Range List.txt' fields terminated by ',' lines terminated by '\r\n'
FROM `higher loan limit leads 2`.`clients` where spare1>'375000' and voicephone<'700000'