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, 213🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...