title: How can write queries in MySQL that can parse JSON data in a column?
body: <p>I have a table in MySQL that has a column that store JSON objects. 
  How can I easily run queries that can have some of the JSON fields in the WHERE clause?</p>
  
  <p>EX: 
    With a table named <code>articles</code></p>
  
  <pre><code>+----+---------+--------------------------------------------------------------------------------------------------+
  | id | user_id | json_data                                                                                        |
  +----+---------+--------------------------------------------------------------------------------------------------+
  |  1 |       1 | {"url":"https://www.cpubenchmark.net/","title": "CPU Benchmarks"}                                |
  |  2 |       1 | {"url":"http://www.ebay.com/sch/CPUs-Processors-/164/i.html","title": "Computer and Processors"} |
  |  3 |       2 | {"url":"https://www.youtube.com/watch?v=tntOCGkgt98","title": "Funny Cats Compilation"           |
  +----+---------+--------------------------------------------------------------------------------------------------+
  </code></pre>
  
  <p>I want to be able to write something like:</p>
  
  <pre><code>   SELECT user_id, json_data FROM articles WHERE json_data.title LIKE "%CPU%"
  </code></pre>
  
  <p>That should return only the first row.</p>