Replace(my_column,'''','')

UPDATE your_table
   SET your_column = REPLACE(your_column, ''', ''');

select replace('abc''def','''','')

Replace(my_column,"'",''')