mysql行转列

SELECT
  t.shsexssjhylydm
  ,count( 1 ) count 
FROM
  (
  select REGEXP_SUBSTR(SHSEXSSJHYLYDM, '[^,]+', 1, L) AS SHSEXSSJHYLYDM,shsexsbh
   from TB_YW_SHSEXS_XS  xs, 
(SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 1000)  
WHERE L(+) <= LENGTH(SHSEXSSJHYLYDM) - LENGTH(REPLACE(SHSEXSSJHYLYDM, ',')) + 1
and  xs.XXSC_PDBZ = '0' AND to_char( xs.DJSJ, 'yyyy' ) = to_char( SYSDATE, 'yyyy' ) 
)t
GROUP BY
  t.shsexssjhylydm;