MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tab(field1 INT, field2 INT)
;

INSERT INTO tab
VALUES(1,2),(NULL,3)

SELECT *
FROM tab 
WHERE field1 <=> field1 and field2 > 0;


field1
field2


1
2

null
3