@Candle said:
select * from [table] order by rand() limit 1
Does this work? Doesn't in TRANSACT-SQL - Rand() is generated once, not once per row.
I've run into this when trying to put random defaults on a
column. Do a multi-row INSERT and they all get the same value for
their random data.