Collections:
CONCAT_WS() - Concatenation with Separator
How to concatenate multiple strings together with a given separator using the CONCAT_WS() function?
✍: FYIcenter.com
CONCAT_WS(separator, string1, string2, ...) is a MySQL built-in function that concatenates multiple strings together. For example:
SET @host = 'dba'; SET @domain = 'FYIcenter'; SET @tld = 'com'; SELECT CONCAT_WS('.', @host, @domain, @tld); -- +--------------------------------------+ -- | CONCAT_WS('.', @host, @domain, @tld) | -- +--------------------------------------+ -- | dba.FYIcenter.com | -- +--------------------------------------+
Reference information of the CONCAT_WS() function:
CONCAT_WS(separator, str1, str2, ...): str Returns the string that results from concatenating the arguments except for the first one, which is used as concatenation separator, like the CONCAT() function. If the separator is NULL, the result is NULL. Arguments, return value and availability: separator: Required. The given separator. str1: Required. The first given string to concatenate for. str2: Optional. The second given string to concatenate for. str: Return value. The string of concatenation of all given strings. Available since MySQL 4.0.
Related MySQL functions:
⇒ CONV() - Binary/HEX String and Integer Conversion
⇐ CONCAT() - Concatenating Strings
2023-11-10, 226🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...