×
Night mode
Sign up
Login
CONCAT_WS
The function is similar to 
CONCAT
where 
WS
means - with separator. The first parameter is the separator between each one of the additional fields, that we pass as next parameters
SELECT 
    CONCAT_WS(' - ', first_name, 'joins', 'strings', 'and', 'columns', 'with', 'separator') 
FROM students
by Valeri Tandilashvili
4 years ago
MySQL
String functions
Full MySQL Course for Beginners
2
Pro tip: use ```triple backticks around text``` to write in code fences