Retrieve Texts from MySQL database
<p>Hi I would like to know the answers of the following queries, </p>

<ol>
<li>What is the maximum size of data a TEXT data type can have in mysql table?</li>
<li>If I would like to store 6000 to 7000 lines of texts (say, LARGE Text) in a particular field what should be the datatype of that field?</li>
<li>What is the process to retrieve the LARGE TEXT data from mysql table in the following two cases using PHP,</li>
</ol>

<p>Case-1 : Retrieve data from a particular field "Messages"</p>

<pre><code>---------------------------
id   |   Messages
---------------------------
1    |  "here LARGE Text... 
</code></pre>

<p>Case-2 : Retrieve all "Messages" data  from a the table.</p>

<pre><code>---------------------------
id   |   Messages
---------------------------
1    |  "here LARGE Text... 
---------------------------
2    | "here another LARGE Text...
</code></pre>