The conditional operator is a ternary-operator that is part of the syntax for a basic conditional expression in several programming languages. It is also commonly referred to as inline if.
The basic format of the conditional operator is this:
condition ? first_expression : second_expression;
A number of languages have a ternary operator consisting of
:. "Conditional operator" is the proper name for this operator, at least in C and C-like languages.
This is MySQL specific and not SQL standard:
C / C++ / C# / Java / PHP
(condition) ? value_when_true : value_when_false ;
value_when_true if condition else value_when_false
VB / VBA
IIF(condition, value_when_true, value_when_false)
The conditional operator is not the only ternary operator, so don't use that name for this operator. Any operator that takes 3 inputs (operands) is a ternary operator, like the SQL
BETWEEN operator and the Python extended slice syntax.