How To Concatenate Two Columns In Sql?
Instead of getting all the table columns using * in your sql statement, you use to specify the table columns you need. Remove the * from your query and use individual column names, like this: SELECT SOME_OTHER_COLUMN, CONCAT(FIRSTNAME, ‘,’, LASTNAME) AS FIRSTNAME FROM `customer`; Can you concatenate fields in SQL? In the output of SQL […]