SELECT SUM(IF(user.name LIKE '%bob%',1,0)) AS `total_bobs`,
IF Boolean_expression BEGIN -- Statement block executes when the Boolean expression is TRUE END ELSE BEGIN -- Statement block executes when the Boolean expression is FALSE END
SELECT IF(500<1000, "YES", "NO");