select query question
| From: | Sunfire | Date: | Mon, 17 Feb 2003 17:19:36 +0000 |
| Subject: | select query question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-135857@lists.php.net to get a copy of this message | ||
hi i have a select query i need to do on a field in my table.. the field is
called Flags and there is 1 char for every flag that is set for a certain
group..
the flags are F S L C G R now what i want to do is search for every instance
of Flags field that has any value except L and C in it and select those
fields..
so the result would be every record that doesnt have L and C in the Flags
field would be selected.. dont know how to do this query i thought it might
be something like this:
mysql_query("select * from members where Flags not like '%l%c%'"); but not
really sure.. i know to use the not like statement but its just figuring out
what search pattern to use...
tnx
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003