> > -----Original Message-----
> > From: ross@stripped [mailto:ross@stripped]
> > Sent: 10 May 2007 10:08
> > To: mysql@stripped
> > 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
