Re: How can I delete redundant duplicates in MySQL?
| From: | CC Zona | Date: | Mon, 16 Oct 2000 23:57:20 +0000 |
| Subject: | Re: How can I delete redundant duplicates in MySQL? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3662@lists.php.net to get a copy of this message | ||
In article <JAEOJEKAAJEANNDILAEPAEGPCBAA.j.ten.berge@getexo.nl>,
j.ten.berge@getexo.nl ("Jeroen ten Berge") wrote:
> lists. I load long files with adresses into MYSQL. I need to filter out the
> redundant duplicates of emails...
If you don't actually need to *delete the records, you can eliminate the
*appearance of duplicates very easily with a select:
SELECT email FROM mail_list GROUP BY email
--
CC