RE: [PHP-DB] mysql exclusion in php
| From: | Beau Lebens | Date: | Thu, 30 May 2002 01:28:41 +0000 |
| Subject: | RE: [PHP-DB] mysql exclusion in php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19512@lists.php.net to get a copy of this message | ||
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 required
query db
-----------------
ok, obviously that's very rough, but i think something like that will work
:)
HTH
Beau
// -----Original Message-----
// From: Chris Payne [mailto:chris@planetoxygene.com]
// Sent: Thursday, 30 May 2002 12:22 PM
// To: php-db@lists.php.net
// 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
//