Changes

-- SELECT 2603422

This table stores records that meet all the requirements above: zip with 5-4 or 5 digits, state not null or not spaces, and city in ptoasigneend_us_citylist.

postcode ~* '\d{5}';

SELECT 2511356

* Part of 'city' contains punctuation. Remove punctuation marks, and then match 'city' with ptoassigneend_us_citylist.

SELECT *, replace(city, ',', '') clean_city

FROM ptoassigneend_us_temp2;

Output: ptoassigneend_us_identify2