Concatenate columns in table code example
Example: Concatenate columns in table
/* Takes several columns to form a single name */
select concat(prefix,' ',first,' ',last,' ',suffix) as title from names
/* Takes several columns to form a single name */
select concat(prefix,' ',first,' ',last,' ',suffix) as title from names