Combination of Three Random Strings with Two Constant Strings

[Jess Stultz]

Hello!
I started teaching myself MySQL a few months ago but I seem to have adopted a project beyond my skill range and could use some assistance.

Currently I am using MySQL 5.6.16 via a Windows command prompt.
I have three different tables in my database: generator_medium, generator_subject, and generator_action.

The essence of my project is to create a string with five different parts:
(Random value from generator_medium) (static string) (random value from generator_subject) (static string) (random value from generator_action). I have attempted variations of "SELECT column FROM table ORDER BY RAND() LIMIT 1;" but none of my attempts return the results I'm looking for.

Any advice is greatly appreciated!