update my_table set clean_hostname = hostname||'houston.com', confidence=95.0 where hostname like '%.q9ix'