How can i use Like in cake php

Question

i want the alternative cakephp code for the above query

Select * from book where title like '%java%;

Answer 1

OK, assuming you are using a find() query.

You can specify the conditions array as follows:

"conditions" => array("Book.title like" => "%java%")

or

"conditions" => array("Book.title like '%java%'")

I think both will work

Answer 2

Docu complex find conditions

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