MySQL is different than

Question

How can i do this

select * from theuser where userid=1233 and active != 1

in the correct MySQL syntax?

activemaybe NULL, 0or 1, and I need active, an equal NULLor 0, never equal 1.

Answer 1

select * from theuser where userid=1233 and (active is null or active != 1)

Answer 2

SELECT *
  FROM theuser
 WHERE userid = 1233
   AND (active IS NULL OR active != 1)