-- Created on savesnippets.com · https://savesnippets.com/0OoZ1Eo8OkrjEn
-- Find rows where the new value DIFFERS from the old value, treating both NULLs as equal
SELECT id, name, old_status, new_status
FROM   audit
WHERE  old_status IS DISTINCT FROM new_status;
-- old=NULL  new='active' → DIFFERENT
-- old='x'   new='x'      → SAME (excluded)
-- old=NULL  new=NULL     → SAME (excluded)

-- Equivalent without IS DISTINCT FROM — verbose, easy to get wrong
WHERE (old_status <> new_status) OR (old_status IS NULL) <> (new_status IS NULL);

-- Use in a MERGE / UPSERT: only update if values actually changed
UPDATE users SET name = $1, email = $2, updated_at = NOW()
WHERE  id = $3
   AND (name, email) IS DISTINCT FROM ($1, $2);

-- MySQL equivalent — the safe-equals operator <=>
SELECT * FROM audit WHERE NOT (old_status <=> new_status);