> > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 10 May 2007 10:08 > > To: mysql@lists.mysql.com > > Subject: adding 3 values > > > > > > Hi, > > > > I have 3 integer values in the table single_rooms, double_rooms, > > twin _ooms but want to add them all up to do a comparison to see > > if the combined number of rooms is less than ten. > > > > Ta, > > > > R. > > > > > > SELECT SUM(single_rooms, double_rooms, twin_rooms) from TABLE; > > Or, if you want a boolean value depending if there are less than 10: > > SELECT IF(SUM(single_rooms, double_rooms, twin_rooms) < 10,1,0) > from TABLE; >
Sorry, brain was switched off when I wrote that. It should be: SELECT single_rooms+double_rooms+twin_rooms from TABLE; Or, if you want a boolean value depending if there are less than 10: SELECT IF((single_rooms+double_rooms+twin_rooms) < 10,1,0) from TABLE; Edward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]