Can I somehow add ''random number code'' to query?

this code works fine for me. I just wanted to ask you, if it's possible to somehow add a random number generator to the TeamProLines.OTForward(number) area.

                        $QueryNextGamePlayerStats = "SELECT * FROM (((TeamProLines INNER JOIN SchedulePro ON TeamProLines.TeamNumber = SchedulePro.HomeTeam) LEFT JOIN PlayerProStat ON TeamProLines.OTForward1 = PlayerProStat.Name) INNER JOIN PlayerInfo ON TeamProLines.OTForward1 = PlayerInfo.Name) WHERE TeamProLines.Day = 1 ORDER BY Play ASC, GameNumber ASC,Day ASC";
                    $NextGamePlayerStats = $db->query($QueryNextGamePlayerStats);

I would like to have TeamProLines.OTForward and number anywhere from 1 to 10 here.

(TeamProLines.OTForward1/TeamProLines.OTForward2/TeamProLines.OTForward3...)

Thank you!