title: Filter a table by id from JSON in MySQL
body: <p>i would like to filter a table from a JSON Array in MySQL. Example:</p>
  
  <pre><code>select description from books where id_of_the_book in (jsonarray)
  </code></pre>
  
  <p>Actually i tried this:</p>
  
  <pre><code>set @test = JSON_ARRAY(JSON_OBJECT('id','1'),JSON_OBJECT('id','2'),JSON_OBJECT('id','3'));
  
  select description from books where id_of_the_book in (select JSON_EXTRACT(@test, '$**.id'))
  
  </code></pre>
  
  <p>but it wont work.</p>
  
  <p>Thank you</p>