#   qryImputeCityFromAddress.sql
#   SQL
#   n6lhv@arrl.net (Wayne Smith)


#   Display the MySQL version
SELECT version();


#  Switch to the correct database
USE uls


#  Change the value
UPDATE pubacc_lo
  SET location_city = 'PASADENA'
  WHERE (location_city = '') AND (
        location_address = 'MT. WILSON ANTENNA FARM'
  )
;