How to use LIKE OR operator using cakephp & mysql.

Question

I am new to cakephp & don't know what is the syntax to use LIKE & OR operator in cakephp with mysql.

Can anyone help me? Thanks..

Answer 1

http://cakephp.prometsupport.com/2008/handling-sql-injection-in-cakephp/

Answer 2

Complex find conditions from the manual:

$this->Post->find('first', array (
    "Author.name" => "Bob", 
    "OR" => array (
        "Post.title LIKE" => "%magic%",
        "Post.created >" => date('Y-m-d', strtotime("-2 weeks"))
    )
));