How to use json column in the WHERE clause as a condition
<p>The question is stated in the title and below is an example of the data</p>

<pre><code>insert into table A values('a','b', {'key':'value'});
</code></pre>

<p>And I would like to be able to select this row based on the key-value pair using the WHERE clause. How can I do that?</p>