Gorm: How to do a select random ? type:question

[gmolveau]

Hi ! Thank you for you work !

I'd like to know if it's possible to do a random select without using RAW SQL ?

For example, in MySQL I would to use " ORDER BY RAND() "
and in Postgres " ORDER BY RANDOM() ".

Thank you for your help !

[jinzhu]

Order(gorm.Expr("rand()")) or Order(gorm.Expr("random()"))

[yreme]

Thanks @jinzhu , It works for me!

Use rand() or random() depend on the database type . For example ,

• use rand() or Order(gorm.Expr("rand()")) in MySQL ,
• use random() or Order(gorm.Expr("random()")) in PostgreSQL or sqlite

More database type can find solution from this answer:
https://stackoverflow.com/questions/580639/how-to-randomly-select-rows-in-sql/1209946#1209946