SELECT name, address, city, state, zipcode, voicephone into outfile 'c:\\transfers.txt'
fields terminated by ',' lines terminated by '\r\n'
FROM `clients` where dateedited between '20080721000000' and '20080721235959' and (spare16 like '1%' or spare16 like '2%')
limit 1000000