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.