Tuesday, June 2, 2015

How to write a query | cakephp 3.x

Please help!
How to write a query to the database according to the conventions cakephp 3.x
SELECT * FROM keywords
WHERE
(kw LIKE %{$word_1}% AND kw LIKE %{$word_2}% AND kw LIKE %{$word_3}%)
 OR
(kw LIKE %{$word_4}% AND kw LIKE %{$word_5}% AND kw LIKE %{$word_6}%)
 NOT
(kw LIKE %{$word_7}% AND kw LIKE %{$word_8}% AND kw LIKE %{$word_9}%)
ORDER BY frequency DESC
;


Important! Any variable ($word_1 - $word_9) can be NULL

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: