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!