Active Record Find - column != value

Yii 1.1 General Discussion
1

This works great:

$model->findAllByAttributes(array(‘some_column’ => 1));

How to I find by ‘some_column’ does NOT EQUAL 1?

Thanks!

2 

$model->findAllByAttributes(array(), 'some_column <> 1');

or


$model->findAllByAttributes(array(), 'some_column <> :some_value', array(':some_value' => $some_value));

or


$model->findAll('some_column <> 1');

etc.

3

Here query is

email is equal to email and user_id is not eqaul to the current model user_id





	$existEmail = Users::model()->findByAttributes(

	array('email'=>$this->email),

	array(

            'condition'=>'user_id!=:id',

        'params'=>array('id'=>$this->user_id),

        ));




		if($existEmail)

		     $this->addError($email,Yii::t('admin','Email is already exist!'));

		else 	

			return true;