Re: Query to combine columns

[Rick James]

SELECT col1, col2, COnCAT(col1, col2) FROM tbl;

Example:

mysql> SELECT city, state, CONCAT(city, state)
        FROM US ORDER BY RAND() LIMIT 11;
+-----------------+-------+---------------------+
| city            | state | CONCAT(city, state) |
+-----------------+-------+---------------------+
| Palatine        | IL    | PalatineIL          |
| Lindsay         | CA    | LindsayCA           |
| Hempstead       | NY    | HempsteadNY         |
| Alderwood Manor | WA    | Alderwood ManorWA   |
| Taft            | CA    | TaftCA              |
| Beaufort        | SC    | BeaufortSC          |
| Madison Heights | VA    | Madison HeightsVA   |
| Seminole        | FL    | SeminoleFL          |
| Longmont        | CO    | LongmontCO          |
| White Oak       | MD    | White OakMD         |
| Douglas         | GA    | DouglasGA           |
+-----------------+-------+---------------------+