Finding duplicates/triplicates records on MYSQL

Posted on Dec 27, 2008 in Codeigniter, PHP, Uncategorized | 0 comments

MySQL statement that will query records with more than 1 results: Example: you will query to display the email address and total count of email address exist on the recordset $sql = "SELECT emailaddress, COUNT(emailaddress) AS TotalCount FROM tbl_users GROUP BY emailaddress HAVING ( COUNT(emailaddress) > 1 )";