title: How to query JSON array in MYSQL with AND
body: <p>If i have json like the following in a column in a mysql database</p>
  
  <pre><code>[
   {
    "name": "John",
    "checked": true
   },
   {
    "name": "Lucy",
    "checked": false
   }
  ]
  </code></pre>
  
  <p>how can I select in mysql all rows where in the same object name = 'John' and checked = true. </p>
  
  <p>The json objects may have more keys and keys may not be in a specific order.</p>