This code is useful if you have a table where some records have been deleted. This code will favor records after large blocks of deleted records.
1) Get max id 2) generate random number with the max id 3) Query DB with random number.
- SELECT MAX(id) FROM table
- $random_num = RAND(0, $max(id));
- SELECT * FROM table WHERE id >= $random_num LIMIT 1
CommentsSubscribe to comments
You need to login to post a comment.