Re: select query question

SELECT * FROM mytable WHERE flags NOT IN('L','C') rick "People will forget what you said. People will forget what you did. But people will never forget how you made them feel." ----- Original Message ----- From: "Sunfire" <rusty_81@msn.com> To: <php-general@lists.php.net> Sent: Monday, February 17, 2003 11:19 AM Subject: [PHP] select query question 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php