concatenate values from columns to make new column sql code example

Example: sql concat string with column value

SELECT CONCAT(name, "string_value") AS name
FROM 
  users;