CONCAT_WS Separator

Question

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 with "," i want to select a seperator than not confilict by field value :(

Answer 1

Hope U R USING PHP

choose your own separator like

$glue=®(alt 0174)


CONCAT_WS($glue,str1,$str2)

Answer 2

From here:

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