Where In (...) With Yii Query Builder

Yii 1.1 General Discussion
1

Hi,

Is there any easy way to do WHERE IN (:wherein) using the Yii Query Builder?

Thanks

2 

->where(array('in', 'id', array(1, 2))

http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder

3

Thanks that works!!!

Is there any way to have both a ‘WHERE IN (…)’ and ‘id=1’ at the same time using Yii query builder?

(So the Where statement looks like: WHERE color IN(‘Red’, ‘Blue’) AND id=1)

Thanks :)

4

Plz read the link.

5

Thanks :)

I always seem too miss the simplest things in Yii

6

guys, can u direct me to a demo where in the query builder is used and to implement join of two tables

as am new to yii help me out :unsure: