Re: [PHP-DB] mysql exclusion in php

You need to parse the string and PHP and generate the appropriate query based on that parsing... ed At 09:22 PM 5/29/2002 -0700, Chris Payne wrote: Hi there everyone, How can I do a search which excludes certain words if they put a - in the search string? I can do a search easily, but if

RE: [PHP-DB] mysql exclusion in php

chris, you'll need to do a little PHP manipulation, perhaps (pseudo) if -word. (regular expression?) for each -word SQL .= NOT LIKE '%word% AND' endforeach endif for each other word SQL .= LIKE '%word%' AND endforeach strip trailing AND clean up SQL as