RE: adding 3 values
-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]
RE: adding 3 values
-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]
Re: adding 3 values
Ok, I have this so far $query = SELECT * FROM properties where single_rooms+double_rooms+twin_rooms10 and rent 100; This is fine but what I really want to do it this $query = SELECT * FROM properties WHERE single_rooms+double_rooms+twin_rooms10 AND single_rooms+double_rooms+twin_rooms10 AND rent 100; This is starting to get messy. Can I set up an alias for the total? I tried this without success. $query = SELECT *, single_rooms+double_rooms+twin_rooms AS total FROM properties WHERE total 2 AND total 10 R. - Original Message - From: Edward Kay [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, May 10, 2007 10:17 AM Subject: RE: adding 3 values -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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: adding 3 values
This is starting to get messy. Can I set up an alias for the total? That's exactly what HAVING is for. PB [EMAIL PROTECTED] wrote: Ok, I have this so far $query = SELECT * FROM properties where single_rooms+double_rooms+twin_rooms10 and rent 100; This is fine but what I really want to do it this $query = SELECT * FROM properties WHERE single_rooms+double_rooms+twin_rooms10 AND single_rooms+double_rooms+twin_rooms10 AND rent 100; This is starting to get messy. Can I set up an alias for the total? I tried this without success. $query = SELECT *, single_rooms+double_rooms+twin_rooms AS total FROM properties WHERE total 2 AND total 10 R. - Original Message - From: Edward Kay [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, May 10, 2007 10:17 AM Subject: RE: adding 3 values -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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]