sql - 将其中带单引号的字符串替换为另一个字符串 SQL

Question

我在一列(称为列 c1)中有一个值，如下所示:

'there it is' is what she said

我想将其替换为:

'there it is plus two' is what she said

但是过得很艰难。

Using replace(c1
    , ''there it is' is what she said'
    , ''there it is plus two' is what she said')

给我“附近的语法不正确”。

Answer 1

在字符串 '' 中引用 ':

replace(c1
    , '''there it is'' is what she said'
    , '''there it is plus two'' is what she said')