摘要:
下文讲述MySQL数据库中函数ELT的功能简介说明,如下所示;
实现思路:
ELT函数的功能,主要根据参数值决定取后面的第几位字符串
ELT函数语法:
ELT(N,str1,str2,str3,...)
当N=1,则返回str1
当N=2,则返回str2
当N=3,则返回str3
当N小于1或超过后面值得数值,则返回 null
例:
mysql> select elt(0,'a','maomao','ttt');
+---------------------------+
| elt(0,'a','maomao','ttt') |
+---------------------------+
| NULL |
+---------------------------+
1 row in set (0.00 sec)
mysql> select elt(4,'a','maomao','ttt');
+---------------------------+
| elt(4,'a','maomao','ttt') |
+---------------------------+
| NULL |
+---------------------------+
1 row in set (0.00 sec)
mysql> select elt(2,'a','maomao','ttt');
+---------------------------+
| elt(2,'a','maomao','ttt') |
+---------------------------+
| maomao |
+---------------------------+
1 row in set (0.00 sec)