mariadb 문자열 합치기

Example:

SELECT CONCAT('Agent', 47);

 

space:

SELECT 
    CONCAT('Agent ', 47) AS "Option 1",
    CONCAT('Agent', ' ', 47) AS "Option 2";

Result:

+----------+----------+
| Option 1 | Option 2 |
+----------+----------+
| Agent 47 | Agent 47 |
+----------+----------+