暂记一下:
update hare t set t.haername = replace(t.haername,'委会','') where REGEXP_LIKE(t.haername,'*村委会$')
update hare t set t.haername = replace(t.haername,'*','') where t.haername like '*%'
update hare t set t.haername = replace(t.haername,'委会','') where REGEXP_LIKE(t.haername,'*村委会$')
update hare t set t.haername = replace(t.haername,'*','') where t.haername like '*%'