> -----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; Edward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]