SELECT for an array field -- Magento
<p>One of the fields in my seller db has following data:</p>

<pre><code>{"delivery area":"delivery amount"}
</code></pre>

<p>An example of this data in the db is as follows:</p>

<pre><code>{"1":"0","2":"0","3":"0","4":"200","5":"1"}
</code></pre>

<p>Now I want to write a query that picks all sellers that deliver to a particular delivery area.</p>

<p>How can I do it using SQL? What do I specify in the WHERE clause?</p>

<p>I am working on Magento so an equivalent in addFieldToFilter will also help.</p>