Beauford, you might find this article on cross joins interesting, it was something shown to me a few weeks ago that discusses this kind of function.
http://dev.mysql.com/tech-resources/articles/wizard/print_version.html Cheers, craig -------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. -----Original Message----- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Friday, September 28, 2007 1:36 PM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Count syntax 1 means that 1 will be added to the sum if the condition tests, otherwise 0 will be added to the sum. the condition in this case is (supportertype = 'L') and will be applied to every row. On 9/28/07, Beauford <[EMAIL PROTECTED]> wrote: > Thanks - it works, but what does the 1 and 0 do in this - > SUM(IF(supportertype = 'L', 1, 0)) > > > -----Original Message----- > > From: Baron Schwartz [mailto:[EMAIL PROTECTED] > > Sent: September 28, 2007 1:00 PM > > To: Beauford > > Cc: mysql@lists.mysql.com > > Subject: Re: Count syntax > > > > Beauford wrote: > > > Hi, > > > > > > I have the following line of code and I keep getting wrong > > results from it. > > > Can someone let me know what I'm doing wrong here. I just > > can't quite > > > figure out the syntax that I need. > > > > > > select count(*) as numrows, count(supportertype) as leadcar from > > > registrar where supportertype = 'L'; > > > > > > What I want to do is count the total number of records and then the > > > total number of records that have "L" as the supportertype > > and then display them. > > > > > > So I should have something like "There are 100 total records and 22 > > > with Supporter Type L". > > > > Try this: > > > > SELECT COUNT(*), SUM(IF(supportertype = 'L', 1, 0)) FROM registrar; > > > > Baron > > > > -- > > 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] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- 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]
