select * from location_csv as lc where lastname = '' UPDATE location_csv SET lastname = NULLIF(lastname, '')