title: How to query with a where clause in mysql json table
body: <p>I am using mysql 5.7.x</p>
  
  <p>I can create a mysql json table </p>
  
  <pre><code> CREATE TABLE t1 (jdoc JSON);
  </code></pre>
  
  <p>I can insert rows.</p>
  
  <pre><code>INSERT INTO t1 VALUES('{"key1": "value1", "key2": "value2"}');
  INSERT INTO t1 VALUES('{"key1": "value11", "key2": "value22"}');
  </code></pre>
  
  <p>I can also get all rows:</p>
  
  <pre><code>SELECT * from t1;
  </code></pre>
  
  <p>How do I use a where clause?</p>
  
  <pre><code>select * from t1 where "key1" = "value1"
  </code></pre>