MySQL select where JSON field property has value : <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>
