how do i display columns as strings in mysql?

June 19, 2022 June 19, 2022 / 1 minute of reading

Use CONCAT to generate the output you want:

SELECT CONCAT(NAME, '.', ID) AS RESULT
FROM COMPANY
WHERE EMPLOYEES > 10000
ORDER BY EMPLOYEES;

CLICK HERE to find out more related problems solutions.