concat 2 sets of columns mysql code example Example: mysql concatenate two columns into one SELECT concat(first_column, ' ', second_column) from table_name