Query a JSON array in Mysql
<p>I have the following JSON object.</p>

<pre><code>SET @j = '{"id": [1, 2, 4]}'
</code></pre>

<p>I'm trying to query the JSON object to find if the id contain 2 in it.</p>

<pre><code>select JSON_CONTAINS(@j,'one','%2')
</code></pre>

<p>I don't think the above <code>JSON_CONTAINS</code> are correct but I'm not sure what would I do to run it.</p>