This function returns a string resulting from the concatenation, or joining, of two or more string values in an end-to-end manner. It separates those concatenated string values with the delimiter ...

select concat(payment_date," - ",amount) as Payment_Date_nd_Amount from sakila.payment; select concat_ws(" - ",Payment_id,last_update,rental_id) as payment_details ...