On 9 May 2006, at 02:22, Chris wrote:
I would run this query:
SELECT
*
FROM mytable
WHERE LOWER(emailaddress) IN
(SELECT
LOWER(emailaddress)
FROM mytable
GROUP BY 1
HAVING COUNT(emailaddress) > 1)
This would show all duplicate emails, I would use the info this
displays to choose which records to change/keep/delete.
May not be the best way, but it would work.
I'm giving it a go, but it's been running for about 4 hours at 60%
CPU so far! Would it be quicker to tell it to use a case insensitive
collation to locate the duplicates?
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.synchromedia.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
