Question: I have a table of product. I have listed the items with pagination using rand() function. When using rand(), it displays the items in random order but the record is repeated while we go from 1 page to another page.
Is it possible to get non repeated items in each page using rand()? If yes how, if no what may be the option for this.

Answer: 
Well, you could generate a random seed when doing the first query (in your app code), and then keep that seed between requests - and supply this seed to the `rand([seed])` function. That should do it...

Of course, the specifics would depend on how exactly your sql code is working at the moment; you *might* need to loop to comsume the first page (or so) of random numbers to ignore.
SELECT column FROM table
ORDER BY RAND()
LIMIT 1