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: 
In a situation like that, I might see if there's a way to create a list of the product IDs (I'm assuming each product has some sort of unique ID) and shuffle it. The list might be stored as a temporary database table or it might be stored as a session variable in your web application, for example... that way you could get access to any part of the randomly ordered list without having to recompute the whole thing from the beginning.

This is obviously best if you have few people accessing the site at any given time, but you expect each of them to go through several pages of the results.
SELECT column FROM table
ORDER BY RAND()
LIMIT 1