Need a corresponding Cake PHP query using find() for my SQL query

[devilinc]

I need someone to translate this into CakePHP style....dont want to use normal queries.....

SELECT * FROM `departments` WHERE `department_name` LIKE '%hi%' OR `department_email LIKE '%hi%'

 

here i use the email or name from a text field input so i will handle it but if u could just translate this it into cakephp thanks a lot!!!

[devilinc]

this is how far i have reached...could anyone advise me if i have written something wrong?

$conditions = array( "OR" => array (
													"department_name LIKE" => "%".$this->data['Department']['department_search']."%",
													"department_email LIKE" => "%".$this->data['Department']['department_search']."%"
    													)
									);
				$search_results = $this->Department->find('all', array('conditions' => $conditions));

[devilinc]

I think the above query does the simple search...thanks for looking though!!!