我的mysql查询如何将‘Şarapıağ’更改为'Sarapci-Cag‘

Question

我的mysql查询如何将Şarapçı Çağ更改为Sarapci-Cag

我试过这个：

SELECT CONVERT('Şarapçı Çağ' USING latin1) -> ?arapç? Ça? 

我能做什么?

Answer 1

在得到结果之后，您可以更改如下：

"ş","ţ","ă" by "s","t","a" using str_replace.

或者你可以访问这里：PHP converting special characters, like ş to s, ţ to t, ă to a