I got it made, Active enum('1') works. Thanks everyone! I had to import old database into MySQL with '1','0' as default. I wanted to enumerate it so that I can easily use False/true without altering anything in the current database configurations.
-----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 10:22 AM To: Scott Hamm; 'Mysql ' (E-mail) Subject: RE: enum TRUE/FALSE [snip] mysql> select count(*) from Associate where Active=FALSE; mysql> select count(*) from Associate where Active=TRUE; [/snip] Why don't you set enum('TRUE','FALSE')? I ask this because normally you would query, when using NULL (all caps), WHERE Active IS NULL or IS NOT NULL. I believe that you have a fundamental misunderstanding about ENUM. You can set the values, and subsequently the default value of the field as you wish and then construct your queries based on that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]