elt

Description

Syntax

VARCHAR elt(INT, VARCHAR,...)

Returns the string at specified index. Returns NULL if there is no string at specified index.

example

1. mysql> select elt(1, 'aaa', 'bbb');
2. +----------------------+
3. | elt(1, 'aaa', 'bbb') |
4. +----------------------+
5. | aaa                  |
6. +----------------------+
7. mysql> select elt(2, 'aaa', 'bbb');
8. +-----------------------+
9. | elt(2, 'aaa', 'bbb')  |
10. +-----------------------+
11. | bbb                   |
12. +-----------------------+
13. mysql> select elt(0, 'aaa', 'bbb');
14. +----------------------+
15. | elt(0, 'aaa', 'bbb') |
16. +----------------------+
17. | NULL                 |
18. +----------------------+
19. mysql> select elt(2, 'aaa', 'bbb');
20. +-----------------------+
21. | elt(3, 'aaa', 'bbb')  |
22. +-----------------------+
23. | NULL                  |
24. +-----------------------+

keywords

1. ELT