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+unsubscr...@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.

Reply via email to