RE: Select and count duplicates

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

Re: Select and count duplicates

* 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 > -

RE: Select and count duplicates

MAIL PROTECTED]] Sent: Tuesday, December 03, 2002 7:27 AM To: mysql list Subject: Select and count duplicates I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I

re: Select and count duplicates

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

RE: Select and count duplicates

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

Fw: Re: Select and count duplicates

- 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

RE: Select and count duplicates

D]] Sent: Tuesday, December 03, 2002 7:27 AM To: mysql list Subject: Select and count duplicates 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 resu

RE: Select and count duplicates

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

Select and count duplicates

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 --- monsters | 3 halloween | 2 headline1