I tried seeding RAND() with RAND(NOW()) and RAND(UNIX_TIMESTAMP())
both of which return a different result, but neither which is random.
So without a seed I come up with the same game over and over, with now() I get a different game over and over, and trying the UNIX_TIMESTAMP I come up with an even different game over and over.
I'll have to use php I guess. this should work though so I'm a bit confused on whats wrong.