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" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
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? [EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to