title: Check json_contains on json of json in mysql table
body: <p>I have json data in my table which contains again json value like below sample data</p>
  
  <p>This is laravel audits, audits table <code>new_values</code> column ( type: text ) record 
  but for this particular case I am not using eloquent or query builder, it is just a raw query </p>
  
  <p><code>{"video_status_ids":"[6, 8, 14, 29]"}</code></p>
  
  <p>now I want to check if this has 8 in it.</p>
  
  <p>I tried</p>
  
  <pre><code>select * from audits WHERE JSON_CONTAINS(new_values, '8', '$.video_status_ids')
  </code></pre>
  
  <p>and</p>
  
  <pre><code>JSON_CONTAINS(audits.new_values, CAST(' . $status . ' AS json), "$.video_status_ids")';
  </code></pre>
  
  <p>I tried <code>json_Search</code> to</p>
  
  <ol>
  <li><p><code>select * from audits WHERE JSON_SEARCH(new_values, 'all', '8', 'video_status_ids', '$[*]');</code></p></li>
  <li><p><code>select * from audits WHERE JSON_SEARCH(new_values, 'all', '8', NULL, '$[video_status_ids.*]');</code></p></li>
  <li><p><code>SELECT * FROM audits WHERE JSON_SEARCH(new_values, 'all', '8', NULL, '$.video_status_ids.*')</code></p></li>
  </ol>
  
  <p>Getting 0 records</p>
  
  <p>and some other queries, but could not get the expected result.</p>
  
  <p>by refering <a href="https://stackoverflow.com/a/44294290/5321614">this</a> but I am getting 0 records on it.</p>