UPDATE 
  cscart_profile_fields 
SET 
  field_type = 'Q' 
WHERE 
  section = 'C' 
  AND field_name = 'city' 
  AND profile_type = 'S'

Query time 0.00013