List:General Discussion« Previous MessageNext Message »
From:Renish Date:November 28 2006 3:33am
Subject:Re: Simple doubt
View as plain text  
Hello all,

I think u guys have mistaken my question,..

The questiion is How will capture the entries which are entered more than 
once...

Like
For example
>>
>> Item table
>>
>> Mango
>> Orange
>> Carrot
>> Papaya
>> Mango
>> Mango

I want to capture only mango cos it is repeated more than once


----- Original Message ----- 
From: "Hal Wigoda" <hwigoda@stripped>
To: "Renish" <koshy.renish@stripped>
Sent: Tuesday, November 28, 2006 11:11 AM
Subject: Re: Simple doubt


> select unique
>
> On Nov 27, 2006, at 8:45 PM, Renish wrote:
>
>> Gurus,
>>
>> How do I go about to selecting an item which is repeated more than  one 
>> in a field in a table.
>>
>> For example
>>
>> Item table
>>
>> Mango
>> Orange
>> Carrot
>> Papaya
>> Mango
>> Mango
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql? 
>> unsub=hwigoda@stripped
>>
> 

Thread
Simple doubtRenish28 Nov
  • Re: Simple doubtPeter Brawley28 Nov
  • Re: Simple doubtRenish28 Nov
    • Re: Simple doubtPeter Brawley28 Nov
  • Re: Simple doubtRenish28 Nov
  • Re: Simple doubtRenish28 Nov
    • Re: Simple doubtPeter Brawley28 Nov
  • Re: Simple doubtViSolve DB Team28 Nov
    • Re: Simple doubtPeter Bradley28 Nov
  • Re: Simple doubtRenish28 Nov
  • Re: Simple doubtRenish28 Nov
    • Re: Simple doubtPeter Brawley28 Nov