PGSQL字符串截取与替换

select * from qa limit 10;

update qa set an=replace(an,'";','')

select split_part(c ,'****', 1),split_part(c ,'****', 2) from qa limit 100

update qa set an=split_part(c ,'****', 2)