What SQL statement can be used to find duplicate entries in a specific column of a database table in PHP?

To find duplicate entries in a specific column of a database table in PHP, you can use a SQL statement with the GROUP BY and HAVING clauses. By grouping the entries based on the specific column and then filtering out the groups that have more than one entry, you can identify the duplicate values. Here is a PHP code snippet that demonstrates how to find duplicate entries in a specific column named 'email' in a table named 'users': 

<?php
// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// SQL query to find duplicate entries in the 'email' column
$sql = "SELECT email, COUNT(email) as count FROM users GROUP BY email HAVING count > 1";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output duplicate entries
    while($row = $result->fetch_assoc()) {
        echo "Duplicate email: " . $row["email"] . "<br>";
    }
} else {
    echo "No duplicate entries found.";
}

$conn->close();
?>

Keywords

SQL statement duplicate entries specific column database table PHP

Related Questions