SELECT company, address, city, state, voicephone, lastresult into outfile 'c:\\transfers.txt'
fields terminated by ',' lines terminated by '\r\n'
FROM `clients` where dateedited between '20061218000000' and '20061218235959' and spare16 like '9%'
limit 1000000