title: JSON JSON_EXTRACT with MySQL
body: <p>I'm using the JSON_EXTRACT with MYSQL and using this command:</p>
  
  <pre><code>SET @j = '{"id" : "1"}';
  SELECT JSON_EXTRACT(@j, '$.id')
  </code></pre>
  
  <p>the result is</p>
  
  <pre><code>"1"
  </code></pre>
  
  <p>but, when I use </p>
  
  <pre><code>SET @j = '[{"id" : "1"}, {"id" : "2"}]';
  SELECT JSON_EXTRACT(@j, '$.id')
  </code></pre>
  
  <p>the result is </p>
  
  <pre><code>NULL
  </code></pre>
  
  <p>I expected this result</p>
  
  <pre><code>"1"
  "2"
  </code></pre>
  
  <p>Any sugestion? I want the list of ID'S from JSON.</p>