how to select a particular row with column value in magento
<p>Normal sql syntax is:</p>

<pre><code>SELECT * FROM TABLE WHERE COLUMNVALUE="OUR VALUE"
</code></pre>

<p>After loading the model</p>

<pre><code>$company1 = $this-&gt;companyFactory-&gt;create();
</code></pre>

<p>company1 module is loaded</p>

<p>How we to select the rows with our column value?    </p>