title: MySQL select where JSON field property has value
body: <p>How to write a basic MySQL query that has a WHERE on a property within a JSON data-type field? I don't see basic where clause q for json fields on SO.</p>
  
  <p>Something like this, but of course these dont work:</p>
  
  <pre><code>SELECT * from my_table where meta_data-&gt;name = 'bob';
  
  SELECT * from my_table where meta_data[name] IS NOT NULL;
  </code></pre>