SQL IF IN code example

Example 1: if in sql

SELECT 
  IF(500<1000, "YES", "NO");

Example 2: in condition in sql

IN condition allows you to easily test
if an expression matches any value
in a list of values.
It is for reducing  multiple OR
conditions in a SELECT, INSERT, 
UPDATE, or DELETE statement.