title: How to use mysql group_concat(concat()) without concat cuts
body: <p>I'm curious why mySQL with group_concat(concat()) doesn't show the full length of result as it should. For the fewer set of result it is okey - the result perfectly shown. But when another set let's say when the result is more than 12. </p>
  
  <p><strong>MySQL code:</strong></p>
  
  <pre><code>SELECT province_id AS prov_id, province_name AS prov_name, count( tent_info.tid ) AS ntent, 
  GROUP_CONCAT( concat(tent_info.tuser, '-', tent_info.tname )
  ORDER BY tent_info.tname ASC
  SEPARATOR ',' ) AS tlist
  FROM tbl_province
  INNER JOIN tent_info ON tbl_province.province_id = tent_info.prov
  WHERE tbl_province.geo_id = '6'
  GROUP BY province_id
  ORDER BY province_name ASC
  </code></pre>
  
  <p><strong>MySQL result:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/uBQjn.png" alt="enter image description here">
  Now the problem is what I said. The result doesn't completely loaded up. I assumed that when the result is more than 12. As the picture shown below.</p>
  
  <p><img src="https://i.stack.imgur.com/kTxt8.png" alt="enter image description here"></p>
  
  <p>Well I think it might because of :</p>
  
  <ol>
  <li>maximum length allow by group_concat or</li>
  <li>misuse of concat() or</li>
  <li>some error in the tlist occurred such as empty text or invalid characters</li>
  </ol>
  
  <p>Please suggest.</p>