Revision history [back]

To obtain the value of a column that does not match between two columns in MySQL using PHP, you can use the following SQL query:

SELECT column_name1 FROM table_name WHERE column_name1 NOT LIKE column_name2;

Then you can execute the query using PHP's mysqliquery() function and fetch the results using mysqlifetchassoc() or mysqlifetch_array() function.

Here's an example code snippet:

//connect to MySQL database
$conn = mysqli_connect("localhost", "username", "password", "database_name");

//check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

//SQL query to select column1 where column1 is not equal to column2
$sql = "SELECT column_name1 FROM table_name WHERE column_name1 NOT LIKE column_name2";

//execute query
$result = mysqli_query($conn, $sql);

//fetch results
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo "Column1 value: " . $row["column_name1"] . "<br>";
    }
} else {
    echo "No records found";
}

//close connection
mysqli_close($conn);