views:

14

answers:

0

This may be really easy but I'm wondering if there is a function in MySQL to have all results wrapped or appended without having to use CONCAT on each part? Something like:

SELECT x, y, z WHERE 1 = 1

Where the results would normally be:

x     | y     | z
blah  |stuff  |junk
big   |small  |huge
good  |bad    |ugly

Instead it returns:

    x     |     y     |   z
fri-blah  |fri-stuff  |fri-junk
fri-big   |fri-small  |fri-huge
fri-good  |fri-bad    |fri-ugly