chris, you'll need to do a little PHP manipulation, perhaps (pseudo)

if "-<word." (regular expression?)
        for each -<word>
                SQL .= " NOT LIKE '%<word>% AND'"
for each <other word>
        SQL .= " LIKE '%<word>%' AND"

strip trailing "AND"

clean up SQL as required

query db

ok, obviously that's very rough, but i think something like that will work



// -----Original Message-----
// From: Chris Payne [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 30 May 2002 12:22 PM
// Subject: [PHP-DB] mysql exclusion in php
// 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 they put a - infront of a word in the string, how can I 
// then get MySQL to search all entries EXCEPT where the word 
// with a - next to it appears?
// Thanks for everything.
// Chris

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to