CakePHP Mysql query with AND condition

Question

I am running a Mysql query in CakePHP but it is not outputting any result though no error is displayed.

Mysql query is this:

SELECT `isbn`, `title`, `author_name` FROM `books` WHERE `author_name` = 'William Rice' AND `title` LIKE '%Course%' ORDER BY `title` ASC

and it outputs results.

And I have written this in CakePHP find function:

$books = $this->Book->find('all', array('fields'=>array('Book.isbn', 'Book.title', 'Book.author_name'),
                                                'conditions'=>array('Book.author_name'=>'William Rice', 
                                                                    'AND'=>array('Book.title'=>'LIKE %Course%')),
                                                'order'=>'Book.title ASC',
                                                  ));

But the query doesn't run. Is AND condition specified like this? Please have a look at it and tell me where is it wrong. Thanks.

Anubhav · Accepted Answer · 2014-02-03 07:14:37Z

1

Do not use AND array:

You have to change your query as given below:

$books = $this->Book->find('all', 
array('fields'=>array('Book.isbn', 'Book.title', 'Book.author_name'),
      'conditions'=>array('Book.author_name'=>'William Rice',
                          'Book.title LIKE'=>'%Course%'),
      'order'=>'Book.title ASC'
      ));

edited Feb 3, 2014 at 7:14

answered Feb 3, 2014 at 7:03

Anubhav

1,6234 gold badges18 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3224207 Over a year ago

Anubhav thanks but I already tried what you suggested. LIKE will be appended to Book.tite

cornelb · Accepted Answer · 2014-02-03 07:03:02Z

0

    $books = $this->Book->find('all', array(
        'fields' => array('Book.isbn', 'Book.title', 'Book.author_name'),
        'conditions' => array(
            'Book.author_name'=>'William Rice',
            'Book.title LIKE'=>'%Course%'
        ),
        'order'=>'Book.title ASC',
    ));

answered Feb 3, 2014 at 7:03

cornelb

6,0663 gold badges22 silver badges30 bronze badges

Comments

Urdesh Kumar · Accepted Answer · 2014-02-03 14:46:15Z

0

You have done only one mistake , Remove 'AND' from your query, after removing 'AND' your query will be like below query.

$books = $this->Book->find('all', array(
        'fields' => array('Book.isbn', 'Book.title', 'Book.author_name'),
        'conditions' => array(
            'Book.author_name'=>'William Rice',
            'Book.title LIKE'=>'%Course%'
            ),
        'order'=>'Book.title ASC',
        )
    );

answered Feb 3, 2014 at 14:46

Urdesh Kumar

1,1401 gold badge17 silver badges23 bronze badges

1 Comment

user3224207 Over a year ago

Thank you urdesh, but even with that AND the query runs fine. The only problem is LIKE should be with fieldname not with value. Such use of AND is valid but redundant in this case because it defaults to AND. For OR condition it is done that way.

Collectives™ on Stack Overflow

CakePHP Mysql query with AND condition

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related