title: MySQL regexp json
body: <p>can you help me with regular expression in Mysql? </p>
  
  <p>i have these rows in a table</p>
  
  <pre><code>{"id":"1","value":"2"},{"id":"2","value":["5"]}
  {"id":"1","value":"2"},{"id":"2","value":["1","5","14"]}
  {"id":"1","value":"2"},{"id":"2","value":["3","2","12"]}
  {"id":"1","value":"2"},{"id":"2","value":["3","1"]}
  </code></pre>
  
  <p>and I want SELECT -> all rows with id:2 and value 5 (first 2 rows).</p>
  
  <pre><code>WHERE `extra_fields` REGEXP '"id":"2","value":\\["5"\\]' ;
  </code></pre>
  
  <p>I tried this REGEXP but it is not correctly working. My REGEXP SELECT only first row.</p>