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 "taţhan [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. júna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select
I made a small DB of people and mach
try:
select limit , 1
eva
-Original Message-
From: Marc Bakker [mailto:[EMAIL PROTECTED]
Sent: 29. marca 2003 16:55
To: [EMAIL PROTECTED]
Subject: MySQL: Selecting a patricular row
Hello,
I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5
rows. I want to sele
i would use following
$query_del = "UPDATE favorites set
favorites='".REPLACE(favorites,'BitOfStringToReplace','NewBitOfString')."'
WHERE
email='$email' AND password = '$pw'";
eva
-Original Message-
From: Dillon, John [mailto:[EMAIL PROTECTED]
Sent: 5. marca 2003 15:53
To: '[EMAIL PROTE
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. I