if statement in function sql code example

Example: if in sql

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