title: Query a JSON column with an array of object in MySQL
body: <p>I have a json column with the follow array:</p>
  
  <pre><code>[
    {
      "id": "24276e4b-de81-4c2c-84e7-eed9c3582a31",
      "key": "id",
      "type": "input",
    },
    {
      "id": "e0ca5aa1-359f-4460-80ad-70445be49644",
      "key": "name",
      "type": "textarea",
      }
  ]
  </code></pre>
  
  <p>I tried the follow query to get the row that has the id <code>24276e4b-de81-4c2c-84e7-eed9c3582a31</code> in the document column, but it returns not results: </p>
  
  <pre><code>select * from jobs WHERE document-&gt;'$[*].id' = "24276e4b-de81-4c2c-84e7-eed9c3582a31"
  </code></pre>
  
  <p>Anyone know how to do the right query? </p>