However, this code could not deal with the situation where column_1 is Null and column_2 is Null too, which does meet your criteria. If it is the case, ten try this [#4124443@0 -ROLIA.NET 相约加拿大网上社区 之 枫下论坛 & 枫下部落, 枫下论坛主坛 ]
However, this code could not deal with the situation where column_1 is Null and column_2 is Null too, which does meet your criteria. If it is the case, ten try this
by
registereduser
(立牌坊)
at
2007.12.16 16:14
(#4124443@0)
SELECT *
FROM table_name
WHERE (column_1 IS NULL AND column_2 IS NOT NULL) OR
(column_2 IS NULL and column_1 IS NOT NULL) OR
column_1 <> column_2;