update combined_output_02_unique_phone
set AreaCode = substr(field9, 6, 3)KoreaDaily URL update
UPDATE combined_output_02_unique_phone
SET URL = field7
WHERE field7 like 'URL%'
do above for field4, field5, field6, etc.
KoreaDaily UniquePhone
sorts out unique phone number from KoreaDaily comprehensive downloads:
SELECT MIN(ID) AS min_ID, field9
FROM combined_output_02
GROUP BY field9
selects Unique phone:
select * from combined_output_02 where ID in (select min_ID from unique_phone)
AreaCode addition:
select combined_output_02_unique_phone.* , AreaCode_TimeZone.StandardTimeZone from combined_output_02_unique_phone LEFT join AreaCode_TimeZone on combined_output_02_unique_phone.AreaCode = AreaCode_TimeZone.AreaCode