title: GROUP_CONCAT and Longtext
body: <p>I need to combine two text fields in the MySQL Database table into One, So I have used the Following SQL script to do it.</p>
  
  <p>Table: tbl_newsitems
  Combine: Need to combine the text in the 'ni_text' with the same 'news_id'
  Table Layout:</p>
  
  <p><img src="https://i.stack.imgur.com/zNg6f.jpg" alt="zNg6f"></p>
  
  <p>Code used to combine the text:
      SELECT
      <code>news_id</code>,
      GROUP_CONCAT(<code>ni_text</code>
      SEPARATOR ' ')
      FROM
      tbl_newsitems
      GROUP BY <code>news_id</code>;</p>
  
  <p>But it won't display the full (Complete) text in the result section. The CONCAT field is trimmed and missing some text. The default Data type for the CONCAT field is TEXT (1024)</p>
  
  <p>Result:</p>
  
  <p><img src="https://i.stack.imgur.com/A7lPA.jpg" alt=""></p>
  
  <p>So how do I combine the whole text into one field without dropping the content. Please give me the script to do this.</p>
  
  <p>Thanks</p>