IF Function
Syntax
IF(expr1,expr2,expr3)
Contents
Description
If expr1
is TRUE
(expr1 <> 0
and expr1 <> NULL
) then IF()
returns expr2
; otherwise it returns expr3
. IF()
returns a numeric
or string value, depending on the context in which it is used.
Note: There is also an IF statement which differs from the
IF()
function described here.
Examples
SELECT IF(1>2,2,3); +-------------+ | IF(1>2,2,3) | +-------------+ | 3 | +-------------+
SELECT IF(1<2,'yes','no'); +--------------------+ | IF(1<2,'yes','no') | +--------------------+ | yes | +--------------------+
SELECT IF(STRCMP('test','test1'),'no','yes'); +---------------------------------------+ | IF(STRCMP('test','test1'),'no','yes') | +---------------------------------------+ | no | +---------------------------------------+
See Also
There is also an IF statement, which differs from the IF()
function described above.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.