title: Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
body: <p>In MySQL 5.7 a new data type for storing <a href="http://dev.mysql.com/doc/refman/5.7/en/json.html" rel="noreferrer">JSON data in MySQL</a> tables has been
  added. It will obviously be a great change in MySQL. They listed some benefits</p>
  <blockquote>
  <p><strong>Document Validation</strong> - Only valid JSON documents can be stored in a
  JSON column, so you get automatic validation of your data.</p>
  <p><strong>Efficient Access</strong> - More importantly, when you store a JSON document in a JSON column, it is not stored as a plain text value. Instead, it is stored
  in an optimized binary format that allows for quicker access to object
  members and array elements.</p>
  <p><strong>Performance</strong> - Improve your query
  performance by creating indexes on values within the JSON columns.
  This can be achieved with “functional indexes” on virtual columns.</p>
  <p><strong>Convenience</strong> - The additional inline syntax for JSON columns makes it
  very natural to integrate Document queries within your SQL. For
  example (features.feature is a JSON column): <code>SELECT feature-&gt;&quot;$.properties.STREET&quot; AS property_street FROM features WHERE id = 121254;</code></p>
  </blockquote>
  <p>WOW ! they include some great features. Now it is easier to manipulate data. Now it is possible to store more complex data in column.
  So MySQL is now flavored with NoSQL.</p>
  <p>Now I can imagine a query for JSON data something like</p>
  <pre><code>SELECT * FROM t1
  WHERE JSON_EXTRACT(data,&quot;$.series&quot;) IN 
  ( 
  SELECT JSON_EXTRACT(data,&quot;$.inverted&quot;) 
  FROM t1 | {&quot;series&quot;: 3, &quot;inverted&quot;: 8} 
  WHERE JSON_EXTRACT(data,&quot;$.inverted&quot;)&lt;4 );
  </code></pre>
  <p>So can I store huge small relations in few json colum? Is it good? Does it break normalization. <strong>If this is possible then I guess it will act like NoSQL in a MySQL column</strong>. I really want to know more about this feature. Pros and cons of MySQL JSON data type.</p>