Mysql> insert into address_book (address_code, name, area, country) select foxpro.mtp.c_phone, foxpro.mtp.first_name, foxpro.mtp.area_code, foxpro.mtp.country from foxpro.mtp where foxpro.mtp.name like “ASH%”;
where foxpro is the database and mtp is the table in the foxpro database.