update my_table set clean_hostname = hostname, confidence=100.0
where hostname in ('first.correct.host', 'second.correct.host', <etc>)
or hostname like '%.mybiz.com'
or hostname like '%.joescompany.net'