title: using JSON_SEARCH to match integer in json data
body: <p>I have some json data in video_status_ids in mysql, I am trying to retrieve all records having 3</p>
  
  <pre><code>MySql version: 5.7.23 
  </code></pre>
  
  <p>Demo records</p>
  
  <pre><code>[3, 6, 9]
  
  [7, 3, 10] 
  </code></pre>
  
  <p>Query</p>
  
  <pre><code>SELECT * FROM `videos` WHERE JSON_SEARCH(video_status_ids, "one", 3);
  </code></pre>
  
  <p>Resulting 0 records</p>