How to select multiple random posts that should have one or two rows with a specific id?

Question

MySQL

How to select multiple random posts that should have one or two rows with a specific id ?

Answer 1

Select * from table where id=14 order by rand() limit 88 - will select a maximum of 88 rows that have an id of 14. But this will be slow, and will slow down as the number of records grows. You can initially generate a random number and use it as the initial shift in limit. Either it’s night, or I didn’t understand completely - at the beginning, talk about a few, then about one or two ...