MySQL different from

Question

How can I do this

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

in a correct MySQL syntax?

active can be NULL, 0 or 1 and what I need is active equal to NULL or 0, never equal to 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)