How to write a where query in cakephp?

write a where query in cakephp

   $var = $this->module->find('all',array('conditions' =>array('name' => 'xyz')));

   this->set('user',$var);

Note:-

where 'all' is putting all field from table;

you can replace 'all' by single field name also;

'name => xyz' is condition of query in cake php;

'user' is a variable which you will use in view folder for a page; // example: foreach($user as $users) in index.php