title: Sqllite : search value from json string
body: <p>I have table name <code>users</code> contain column name <code>user_email</code>. <code>user_email</code> column having data in json format like below.</p>
  
  <pre><code>[
    {
      "card_email_id": "98",
      "card_id": "88",
      "email": "raj@ccs.sg",
      "type": "Home"
    },
    {
      "card_email_id": "99",
      "card_id": "88",
      "email": "maulik@ccs.sg",
      "type": "Home"
    }
  ]
  </code></pre>
  
  <p>I want to query that search value from json string in only <code>email</code> values.</p>
  
  <p>I already tried REGEXP but that is not supported in sqlite.</p>
  
  <p><strong>is this possible using <code>LIKE</code> operator or something else?</strong></p>