Quick Tip: MySQL Concat

While working on a project, I was looking for a way to join to mysql columns without using php or .Net. This function is called "concat" and allows you to join together 2 columns as one.

SELECT
    CONCAT(firstname, ' ', lastname) As fullname
FROM examples

Check out out the Official Manual Reference for more examples and information.

Hope this helps someone else!