如果多个匹配呢?我选择了小的id,如下:
update b set b.id = (select min(a.id) from a where a.host like '%'||b.host)where exists(select 1 from a where a.host like '%'||b.host)