Question

I have two columns in my SQL table where the phone numbers are stored. I have displayed both the numbers separated by a ",". If I concatenate both the data with "," for displaying, the problem I am facing is - when the first column is blank I am getting the output as ",xxxxxxxxxx" and when the second column is blank I am getting the output as "xxxxxxxxx,". I am getting the perfect output only when both the columns contain data like "xxxxxxxxx,xxxxxxxxx".

How can I remove the extra "," when the data for either of the columns are missing?

Answer 1

This will do the trick.

$ret = implode( , , array_filter(array($value1, $value2)));

Answer 2

www.un.org/Depts/DGACM/index_spanish.htm WHY 检查在MySQL Query内使用PHP?

您在用。

SELECT CONCAT_WS(  , , NULL ,  col2  ) ;

<>蓬特>PUT:col2

然而,只有在空地被定为NUL的情况下,才会这样做。如果你空出的田地为NUL,你可以进一步提出<条码>条件,将这一参数定为<条码>。如果外地空闲,例如

 SELECT CONCAT_WS(  , , IF(col1 =   , NULL, col1) ,  col2  ) ;

友情链接