title: how to get total number of records from multiple records in mysql query
body: <p>I have run this below query </p>
  
  <pre><code>SELECT 
      SUBSTRING_INDEX(prim_key ,":" , 1) prim_key, 
      SUBSTRING_INDEX(prim_key ,":" , -1) urid, 
      CASE WHEN basicname = 'Q914'  THEN 'SHC'
           WHEN basicname = 'QP913'  THEN 'PHC'
           WHEN basicname = 'QC1214'  THEN 'CHC'
           WHEN basicname = 'QD1014'  THEN 'DH/SDH'
           ELSE 'UNKOWN' 
      END AS Status 
  FROM facility_data 
  WHERE 1 = 1
      AND basicname in ( 'Q914'  , 'QP913' , 'QC1214' , 'QD1014' ) 
      and prim_key like  '3_10_%' 
  ORDER BY  prim_key ASC
  </code></pre>
  
  <p>I need to modify slightly, I want it to display total no of SHC , DH , PHC and CHC.</p>
  
  <p>So please tell me what should i do to display Total no  of shc, dh,phc and chc.</p>