$arr = explode(",",$sql);
print_r($arr);

解决方案 »

  1.   

    不行,还是会把to_char(UNIT_DATE,'YYYY-MM-DD HH24:MI:SS')分割开!
    请注意要求!
      

  2.   

    $pattern1 = "/(,[^,\(\)]*\([^,\(\)]*),([^,\(\)]*\)*,)/";
    $sql="id,name,pass,to_char(UNIT_DATE,'YYYY-MM-DD HH24:MI:SS'),level";
    $sql2 = preg_replace($pattern1, "\$1@@\$2", $sql);
    $arr = explode(",", $sql2);
    foreach ($arr as $k=>$i)
    $arr[$k]= str_replace("@@",",",$i);
    print_r($arr);
      

  3.   

    $sql="id,name,pass,to_char(UNIT_DATE,'YYYY-MM-DD HH24:MI:SS'),level";$sql=str_replace("UNIT_DATE,","UNIT_DATE.",$sql);$a=explode(",",$sql);foreach ($a as $v)
    {
    $b[]=str_replace("UNIT_DATE.","UNIT_DATE,",$v);}var_dump($b);