PHP中的rand（）函数问题

Question

I'm having a little trouble with my rand() function. I have the following query:

$listTrainers = mysqli_query($conn, "SELECT emp_id FROM employees;"); 

    while($fetchTrainers = mysqli_fetch_row($listTrainers))
    {
        echo 'ID: ' . $fetchTrainers['0']. '<br>';

    }

This query returns me the id of all employees in the database, is there a way I can randomly select one of these id's and store it in a variable?

I am trying to use the following function:

echo(rand(begin, end));

where begin is the first element from the query and end is the last element

Answer 1

add this to your query:

ORDER BY RAND() LIMIT 1