title: MySQL REGEXP multiline text
body: <p>I need help to write a MySQL Regexp search pattern</p>
  
  <p>In a table, I have a multiline text column, for example :</p>
  
  <p><strong>Row 1</strong></p>
  
  <pre><code>4926
  1615
  3872
  248
  </code></pre>
  
  <p><strong>Row 2</strong></p>
  
  <pre><code>13872;100=HA&amp;ee
  </code></pre>
  
  <p><strong>Row 3</strong></p>
  
  <pre><code>38726;100=HA&amp;ee
  </code></pre>
  
  <p><strong>Row 4</strong></p>
  
  <pre><code>3872
  </code></pre>
  
  <p><strong>Row 5</strong></p>
  
  <pre><code>248
  3872;100=VA
  4926
  1615
  </code></pre>
  
  <p><strong>Row 6</strong></p>
  
  <pre><code>3872;
  248
  4926
  </code></pre>
  
  <p>I want to select the values that contains at least one line beginning with "3872" exactly.
  In our examples, the correct results would be <strong>row 1, 4, 5 and 6</strong>.</p>
  
  <p>Thanks for your help!</p>