select distinct(headlines), count(headlines)
from table
group by headlines
-Original Message-
From: David Shapiro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 8:40 AM
To: 'Michelle de Beer'; mysql list
Subject: RE: Select and count duplicates
Run this qu
* Michelle de Beer
> I have a column containing headlines. In this column
> there are some duplicates, like this:
> ---
> monsters
> headline1
> monsters
> halloween
> monsters
> halloween
> ...
> --
>
> How can I get a result like this instead?
> HEADLINE | HITS
> -
Run this query as rs1:
select distinct scary_words from monsters_table;
String word;
String query;
Int count;
while rs1.next() {
word = rs1.getString();
// Run this sql query as rs2
query = 'select count(*) from monster_table where scary_words="' +
word + '"';
Michelle,
Tuesday, December 03, 2002, 2:27:00 PM, you wrote:
MdB> I have a column containing headlines. In this column
MdB> there are some duplicates, like this:
MdB> ---
MdB> monsters
MdB> headline1
MdB> monsters
MdB> halloween
MdB> monsters
MdB> halloween
MdB> ...
MdB> --
MdB> H
SELECT headline, count(*) AS HITS from your_table GROUP BY headline
> -Original Message-
> From: Michelle de Beer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 03, 2002 8:27 AM
> To: mysql list
> Subject: Select and count duplicates
>
>
> I have a column containing headlines. In
- Original Message -
From: <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 1:05 PM
Subject: Re: Re: Select and count duplicates
> Your message cannot be posted because it appears to be either spam or
> simply off topic
Run this query as rs1:
select distinct scary_words from monsters_table;
String word;
String query;
Int count;
while rs1.next() {
word = rs1.getString();
// Run this query as rs2
query = 'select count(*) from monster_table where scary_words="' +
word + '"';
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
