this should work:
select NAME, sum(if(IF_PURCHASED='true',COUNT,0)),
sum(if(IF_PURCHASED='false', COUNT,0)) from TABLENAME group by NAME;
eva
-Original Message-
From: cengiz tahan [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 9:29 AM
To: [EMAIL PROTECTED]
Subject: Can I do
peopleID should match:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 2. jna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select
I made a small DB of people and
select headline, count(*) from headlines_table group by headline;
Eva Parackova
[EMAIL PROTECTED]
-Original Message-
From: Michelle de Beer [mailto:[EMAIL PROTECTED]]
Sent: 3. decembra 2002 13:27
To: mysql list
Subject: Select and count duplicates
I have a column containing headlines.