Mysql中concat_ws如果是空的,如何不被分隔符分开
Mysql中concat_ws如果是空的,如何不被分隔符分开SELECT CONCAT_WS(",",IF(1>2,"1",""),"1","2","3")输出为: ,1,2,3如果不想要前面的,号,可以把改为null,表示不输出。 SELECT CONCAT_WS(",",IF(1>2,"1",NULL),"1","2","3") 输出为:1,2,3