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!