AR: "WHERE column = x OR column = y"

Archives Yii 1.0.x Discussions
1

I have the following problem, I want to create an "OR" statement via the AR model, but I cant seem to find how I can input multiple values for 1 field.

I want to get back all posts that contain 'tag1' OR 'tag2', how do I do this?

Something like:



$posts = Tag::model()


	->with('posts')


	->findAllByAttributes(


		'name' => array('tag1', 'tag2')


	);
2

This is out of memory, so I may be wrong:

$posts = Tag::model()


->with('posts')


->findAll("`name` IN('tag1', 'tag2')");
3

This works, thanks!

But I'm assuming there is no escaping done here, so I have to do this by hand?

4

yes, http://www.yiiframew…oteValue-detail