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)
精彩评论