mysql> SELECT * FROM tab1;
+--------+-------+------------+-----------+--------+--------+
| id     | runid | generation | durchlauf | caseno | result |
+--------+-------+------------+-----------+--------+--------+
| 100095 |     0 |          7 |         3 |      4 |      7 | 
| 100003 |     0 |          1 |         2 |      4 |      6 | 
| 100030 |     0 |          2 |         1 |      4 |     13 | 
| 100042 |     0 |          3 |         3 |      3 |      8 | 
| 100021 |     0 |          2 |         2 |      3 |      4 | 
| 100080 |     0 |          4 |         1 |      3 |      5 | 
| 100037 |     0 |          4 |         2 |      2 |      5 | 
| 100045 |     0 |          4 |         1 |      2 |      7 | 
| 100014 |     0 |          1 |         1 |      1 |     25 | 
| 100036 |     0 |          1 |         2 |      1 |     12 | 
| 100040 |     0 |          2 |         3 |      1 |      8 | 
| 100094 |     0 |          3 |         4 |      1 |      3 | 
+--------+-------+------------+-----------+--------+--------+
12 rows in set (0.00 sec)

mysql> SELECT 
    CONCAT(
        'xyz ',
         (
            SELECT 
                generation 
            FROM 
                tab1 
            WHERE 
                id = 100040
        ), 
        ' abcd ', 
        (
            SELECT 
                result 
             FROM
                tab1 
            WHERE 
                id = 100094
          )
    ) AS concat;
+--------------+
| concat       |
+--------------+
| xyz 2 abcd 3 | 
+--------------+
1 row in set (0.00 sec)