CakePHPでの検索条件例集
condition
OR, プレースホルダ
$conditions = array(
'OR' => array(
array('startDate > date(?)' => array($today)),
array('endDate < date(?)' => array($today)),
)
);
array('Post.read_count BETWEEN ? AND ?' => array(1,10))
大小
$conditions = array(
'Task.date >=' => $start,
'Task.date <=' => $end
);
否定
array("Post.title !=" => "This is a post")
IN(…)、 NOT IN
array(
"Post.title" => array("First post", "Second post", "Third post")
)
array(
"NOT" => array("Post.title" => array("First post", "Second post", "Third post"))
)
比較
array("Post.created = Post.modified")
LIKE
array(
"Author.name" => "Bob",
"OR" => array(
"Post.title LIKE" => "%magic%",
"Post.created >" => date('Y-m-d', strtotime("-2 weeks"))
)
)
データを取得する - CakePHP Cookbook v2.x documentation
http://book.cakephp.org/2.0/ja/models/retrieving-your-data.html
