Hi Renish,
If you want to capture the entries which are entered more than once. Here's
the answer for it.
mysql> select * from a;
+--------+
| b |
+--------+
| pen |
| pencil |
| rubber |
| pen |
| paper |
| paper |
+--------+
6 rows in set (0.00 sec)
mysql> select b from a group by b having count(b)>1;
+-------+
| b |
+-------+
| paper |
| pen |
+-------+
2 rows in set (0.00 sec)
Hope this helps.
Thanks,
ViSolve DB Team.
----- Original Message -----
From: "Renish" <koshy.renish@stripped>
To: "Hal Wigoda" <hwigoda@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, November 28, 2006 9:03 AM
Subject: Re: Simple doubt
>
> 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
>>>
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
