Hello, I successfully populated a single column in a new table with a text file I had using LOAD DATA INFILE command. I know that there are redundant entries in the list that I would like to eliminate. I would like some help designing a query to identify redundant entries and then to delete them. If there is not an option to delete the extraneous entries then I can use a DELETE { } WHERE { } query. Thank you, Daniel Greenwood --------------------------------------------------------------------- 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