What are the functions of the concat_ws function in MySQL?

2 years ago
Benjamin Taylor
1 minute

The CONCAT_WS function in MySQL is used to combine strings and can also include a separator between the strings.

The function takes two or more parameters, with the first parameter specifying the string to be used as a separator, and the following parameters being the strings to be joined.

Features include:

  1. Concatenating strings: Combining multiple strings into one string.
  2. Add separators: You can include specified separators between the connected strings.
  3. Ignore NULL values: If there are any NULL values in the strings to be concatenated, the function will automatically ignore them.
  4. It can connect values of different data types, such as strings, numbers, etc.

For example, here is an example of using the CONCAT_WS function to concatenate strings:

The output will be “apple,banana,orange” after executing the following statement: SELECT CONCAT_WS(‘,’, ‘apple’, ‘banana’, ‘orange’);

The output will be “2021-08-15” after executing the code SELECT CONCAT_WS(‘-‘, ‘2021’, ’08’, ’15’).

The output will be “Hello World”, disregarding the NULL value.

bannerAds