摘要:
下文讲述MySQL数据库中case关键字的用法说明,如下所示:
MySQL数据库case关键字功能说明:
MySQL case关键字是将一组条件和一组表达式进行匹配,当满足一组条件时,则返回相应的表达式信息并跳出当前case循环;
case关键字功能类似于if函数进行嵌套操作。
——————————–
MySQL case 语法如下:
CASE
WHEN condition_1 THEN 表达式A
WHEN condition_2 THEN 表达式B
...
ELSE 表达式C
END `case 返回结果`;
MySQL case 关键字举例:
mysql > select host,user,case when user ='root' then 'systemuser' else 'otherUser' end as userInfo from user limit 10;
+--------------+------+------------+
| host | user | userInfo |
+--------------+------+------------+
| 127.0.0.1 | root | systemuser |
| tytytutututu | | otherUser |
| 7urtrteererZ | root | systemuser |
| localhost | root | systemuser |
+--------------+------+------------+
4 rows in set (0.00 sec)