Shuffle mysql record

I guess if you can retrieve them in random order, but need to make that random order repeatable, then you just create an incrementing field as you store them in the second table. That way you can continue to retrieve them from the second table in the random order you first got them in. Or you could add an “order” column in the first table, retrieve them in random order and put the incrementing number in that - then while you need to keep retrieving them in that same order, you just order by that column.