Collections:
ELT() - String at Given Index
How to retrieve the string at a given index in a string list using the ELT() function?
✍: FYIcenter.com
ELT(N, str1, str2, ...) is a MySQL built-in function that returns the string at a given index in a string list. For example:
SELECT ELT(3, 'Orange', 'Banana', 'Apple'); -- +-------------------------------------+ -- | ELT(3, 'Orange', 'Banana', 'Apple') | -- +-------------------------------------+ -- | Apple | -- +-------------------------------------+
Reference information of the ELT() function:
ELT(N, str1, str2, ...): str Returns the Nth element of the list of strings: str1 if N = 1, str2 if N = 2, and so on. Returns NULL if N is less than 1, greater than the number of arguments, or NULL. Arguments, return value and availability: N: Required. The index in the string list. str1, str2, ...: One or more strings to form the string list. str: Return value. The string at the given index in the string list. Available since MySQL 4.0.
Related MySQL functions:
⇒ FIELD() - Find String in String List
⇐ CONV() - Binary/HEX String and Integer Conversion
2023-11-12, 219🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...