mysql - SQL Server 到 MySQL 函数在值中使用撇号、引号和逗号

Question

我有无法解决的问题。我所做的选择返回 8500 多个值，其中许多包含撇号、引号、逗号 (")(')(,)。
我正在使用 sql 到 mysql 连接。

所以这不是我需要处理的一个值。我知道如何使用“Eat at Joe's -- It's Good Food!”或“Eat at Joe's -- It's Good Food!”来处理一个值。
有人可以帮我吗

DECLARE @dogno varchar(5)
DECLARE @ime VARCHAR(200)
DECLARE @adresa VARCHAR(200)

DECLARE nam CURSOR FOR
    select Klienti.naziv as ime, Ulici.naziv+' '+Klienti.ulica_br as adresa , tKlienti_Dogovori.dogovor_br as dogno 
    from Klienti_Dogovori
    INNER JOIN Klienti on Klienti.id=Klienti_Dogovori.klient_id
    INNER JOIN Ulici on Ulici.id=Klienti.ulica_id
    where Klienti_Dogovori.usluga_id=2 and Klienti_Dogovori.aktiven=1
open nam
    fetch next from nam into @ime, @adresa, @dogno
    while @@FETCH_STATUS = 0 BEGIN
    DECLARE @sync varchar(max)
            set @sync = '''update users set name=''' +cast(@ime as VARCHAR(200))+ ''', address=''' +cast (@adresa as varchar(200))+ ''' where dognumber=''' + cast (@dogno as varchar(5))
        Execute(@sync) at mysqlserver
    fetch next from nam into @ime, @adresa, @dogno
    END
close nam
deallocate nam

此函数可以正常工作，直到其值包含撇号、引号或逗号 (")(')(,)。

Answer 1

既然我知道如何做，我就回答我的问题。一切尽在选择

select replace(replace(replace(replace(replace(replace(REPLACE(Klienti.naziv,'''',''),'"',''),',',''),'“',''),'„',''),'’',''),'‘','') as ime, replace(replace(replace(replace(replace(replace(replace(Ulici.naziv+' '+Klienti.ulica_br,'''',''),'"',''),',',''),'“',''),'„',''),'’',''),'‘','') as adresa,  Klienti_Dogovori.dogovor_br as dogno
    from Klienti_Dogovori
    INNER JOIN Klienti on Klienti.id=Klienti_Dogovori.klient_id
    INNER JOIN Ulici on Ulici.id=Klienti.ulica_id
    where Klienti_Dogovori.usluga_id=2 and Klienti_Dogovori.aktiven=1