[FIXED] Between query in cakephp 3.3

Issue

THE QUERY IS WORKING

Want to write the query below by using cakephp 3.3

SELECT 

Books.id AS Books__id, Books.title AS Books__title, Books.for_min_age AS Books__for_min_age, Books.for_max_age AS Books__for_max_age, Books.for_min_grade AS Books__for_min_grade, Books.for_max_grade AS Books__for_max_grade FROM books Books WHERE 4 BETWEEN Books.for_min_age AND Books.for_max_age OR 2 BETWEEN Books.for_min_grade AND Books.for_max_grade

Solution

I achieve this by -

 $this->find()->where([$age . ' BETWEEN Books.for_min_age AND Books.for_max_age OR ' . $grade . ' BETWEEN Books.for_min_grade AND Books.for_max_grade']);

Answered By - Mumtaz Ahmad