if you want to find an entry whith "blue": obviously: "WHERE fieldName LIKE '%blue%' "
OR - if you dont want anything after the word "blue": "WHERE fieldName LIKE '%blue' " On 9 Apr., 23:07, Miles J <[email protected]> wrote: > NOT LIKE '%term%' > > Is that what you mean? > > http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
