Fibilt
try:
SELECT id, concat(lname, fname) as name, count(*) as cnt
FROM table1
GROUP BY name
HAVING cnt > 1;
This is close anyhow.
David
> -----Original Message-----
> From: Phillip S. Baker [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 16, 2002 1:17 PM
> To: [EMAIL PROTECTED]
> Subject: Query for multiple rows
>
>
> Greetings all,
>
> I have a users table in the DB.
> I am importing allot of existing data from various places
> into this users
> table.
> There is a strong likelihood of the same user getting entered twice.
> Though each record will have a separate and unique ID, I want
> to be able to
> query the table and look for duplicate records based on first
> name last name.
>
> So for clarity I want to execute a query to one table.
> The results I want displayed are a listing of records that
> have the same
> first name and last name of other records in that same table.
>
> Am I making this clear and what do I need to do?
>
> Thanx
>
> Fibilt
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
