-- SELECT CONCAT(author_fname, ' ', author_lname) AS full_author_name FROM books -- SELECT CONCAT_WS(' ', author_fname, author_lname) AS full_author_name FROM books ...

This page shows you the most commonly used MySQL string functions that allow you to manipulate character string data effectively. CONCAT Concatenate two or more strings into a single string. CONCAT_WS ...