title: MYSQL REGEXP search in JSON string
body: <p>I'm a beginner in regexp and i try to search in json formatted text, but i cannot make it work right:</p>
  
  <pre><code>SELECT DISTINCT tag, body FROM pages 
  WHERE (body REGEXP BINARY '"listeListeOuiNon":".*1.*"')
  </code></pre>
  
  <p>It shows me as results text with </p>
  
  <p><code>"listeListeOuiNon":"1"</code> and </p>
  
  <p><code>"listeListeOuiNon":"1,2"</code> and </p>
  
  <p><code>"listeListeOuiNon":"0,1"</code> <code>as expected</code>, </p>
  
  <p>but also <code>"listeListeOuiNon":"2" (not expected)</code></p>
  
  <p>Any idea?
  Maybe it's because it's greedy, but i'm not sure...</p>
  
  <p>Thanks in advance!</p>