select query question

From: 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

« previous php.general (#135857) next »