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