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)
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)