how to make sql query with and in yii active record? <p>I am new in Yii. Now i have encountered problem with active record in yii.</p> <p>So , I have normal sql here :</p> <pre><code> $sqlText = "SELECT * FROM tbl_webservicetokens WHERE clienttoken = '{$appToken}' AND systimestamp &lt; expiredate"; </code></pre> <p>I want to use active record. But i endeavored </p> <pre><code>$post=TBLWEBSERVICETOKENS::model()-&gt;find( 'CLIENTTOKEN=:appToken AND EXPIREDATE&gt;:systimestamp', array( ':appToken'=&gt;$appToken, ':systimestamp'=&gt;'systimestamp')); </code></pre> <p>But i had error! any idea?</p>