开发者

CONCAT_WS Separator

开发者 https://www.devze.com 2023-02-24 12:37 出处:网络
i want to select a separator for CONCAT_WS() that not confilict by field value for example if i select \",\" maybe field value have string w开发者_开发技巧ith \",\"

i want to select a separator for CONCAT_WS() that not confilict by field value for example if i select "," maybe field value have string w开发者_开发技巧ith "," i want to select a seperator than not confilict by field value :(


From here:

CONCAT_WS(char(22 using utf8), "this", "that");


Hope U R USING PHP

choose your own separator like

$glue=®(alt 0174)


CONCAT_WS($glue,str1,$str2)
0

精彩评论

暂无评论...
验证码 换一张
取 消