oh... no I ment it in a different way.. somehow.. declare 1 enum value and then set it or not. Search for NULL or not NULL values instead of false /true.
in this direction, but .. hey does nobody do this like that?? Andy -- ---------------------------------------------------- http://www.globosapiens.net Global Travellers Network! "Raquel Rice" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Sat, 10 Aug 2002 17:41:56 +0200 > "andy" <[EMAIL PROTECTED]> wrote: > > > > > Hi there, > > > > > > > > I am searching for the best way to store true or false inside > > > > a MySQL DB. With best I mean the most data efficient way and > > > > in the same time the best for fast searching later on the > > > > table to find all which are false, or true. I think I did read > > > > something about a way to do this with ENUM, but cant remember > > > > where and how, all tryes did not succeeed so far. > > > > > > > > Thanx for any help on that. > > > > > > > > Andy > > > > > > How about as a "tinyint" ... 0/1 > > > > > > -- > > > Raquel > > > > hmm.. thats how I am doing it right now. There might be a better > > way?! > > I've never used ENUM, so take what I say with a grain of salt. It > appears to me that if you use "true" or "false" as your ENUM values, > those values are stored as strings. In PHP you would then have to > do string comparisons rather that > "if ($a) { > do this; > }" > > Perhaps it depends upon how you use it ... what you do with it? > > -- > Raquel > ============================================================ > The world is not good enough - we must make it better. > --Alice Walker > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
