If you didn't specified a DEFAULT value, the columns have possibly a NULL value.
So SELECT * FROM T WHERE F IS NULL will select the rows, and UPDATE T SET F = FALSE WHERE F IS NULL will do the update for a table T and a field F. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Andreas Ernst [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 20, 2005 4:04 PM > To: SAPDB > Subject: undef. Boolean > > Hi, > > i altered a table and added a boolean field. I did not write > 'false' to > all rows. > > Now i have changed some rows to 'true', and now i want to set > the undef. > boolean columns to 'false'. > > But, how do i select them? > > regards > Andreas > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
