title: Mysql | How to SELECT integer value from Mixed Integer String?
body: <p>I have been searching now for hours.</p>
  
  <p>Got a String like: <code>"_1_11_19_12_17_21_41_111_100_1"</code></p>
  
  <p>Now, I want the Output to be a single <code>1</code></p>
  
  <p><strong>When I try:</strong></p>
  
  <pre><code>"SELECT * FROM jobs_tb  WHERE position_id LIKE '%1%' "
  </code></pre>
  
  <p>This prints all most everything:</p>
  
  <p><strong>I tried:</strong></p>
  
  <pre><code>SELECT *
  FROM `jobs_tb`
  WHERE (
  `position_id` LIKE '%_1%'
  )
  OR (
  `position_id` LIKE '%_1_%'
  )
  </code></pre>
  
  <p>All most the same as the previous.</p>
  
  <p><strong>How do you isolate a <code>1</code> when <code>1</code>s are mixed with other numbers?</strong></p>
  
  <p>Any suggestion is highly welcomed</p>