Mysql 常用函数总结（控制流函数）

IF(test,arg1,arg2) 如果test是真，返回t；否则返回f

SELECT IF(1 = 1,2,3)
2

SELECT IF(1 = 2,2,3)
3

IFNULL(arg1,arg2) 如果arg1不是空，返回arg1，否则返回arg2

SELECT IFNULL(1,2)
1

SELECT IFNULL(null,2)
2

case语句

参考

WHEN [conditional test 1] THEN [result 1]
WHEN [conditional test 2] THEN [result 2]
ELSE [default result]
END

SELECT

CASE 5
WHEN 1 THEN
    "this is a"
WHEN 2 THEN
    "this is b"
WHEN 3 THEN
    "this is c"
WHEN 4 THEN
    "this is d"
ELSE
    "error"
END

error


SELECT

CASE 1
WHEN 1 THEN
    "this is a"
WHEN 2 THEN
    "this is b"
WHEN 3 THEN
    "this is c"
WHEN 4 THEN
    "this is d"
ELSE
    "error"
END

this is a