MySQL Where condition with CASE

WHERE CASE WHEN cksp.status IS NOT NULL THEN ckspc.is_include_in_pipeline = 1 
      ELSE 1=1 
      END

Here i want like if cksp.status is not null then condition should be cksp.is_include_in_pipeline = 1 ELSE ignore the where condition

Answer

That logic should be similar to:

(cksp.status IS NOT NULL and ckspc.is_include_in_pipeline = 1) or cksp.status IS NULL