使用rand（）函数im mysql

i am using MySQL back-end and in one table there are records of similar id (id column is not primary key), and i want to fetch record randomly on the basis of different id i mean same id record will come together. Is it possible ?. if any body have any idea please share.i am using MySQL back-end and in one table ther