title: Is there a way to not show unwanted text in a long varchar in MySQL
body: <pre><code>SELECT ID, Time, IF(Media=1, 'Yes', 'No') AS Media, Text FROM Database.data;
  </code></pre>
  
  <p>The Text is a <code>varchar(2000)</code> and i would like to take out some specified text from it.
  This doesnt seems to work</p>
  
  <pre><code>SUBSTRING ("*******" FROM Text FOR 6)
  </code></pre>
  
  <p>Is it possible to get the text below returned somehow,
  i dont know the place for the text so LEFT and RIGHT doesnt seem to work here, maybe its possible to use the <code>*****</code> as a starting point somehow, that text is always there and is the only thing near the information i want.</p>
  
  <p>Its ok to if the output comes in 2 columns </p>
  
  <p>Example:</p>
  
  <pre><code>This
  is garbage text
  
  More garbage
  I want this information.
  *******This text is always 6char.
  More garbage here.
  and here
  </code></pre>