Vhernne
Vhernne
Programming language:Whatever
2021-06-24 02:05:24
0
Q:

gorm order by

Aryendu Kumar
Aryendu Kumar
Code: Whatever
2021-08-23 03:21:29 
db.Order("age desc, name").Find(&users)
// SELECT * FROM users ORDER BY age desc, name;
// Multiple 
ordersdb.Order("age desc").Order("name").Find(&users)
// SELECT * FROM users ORDER BY age desc, name;
db.Clauses(clause.OrderBy{  Expression: clause.Expr{SQL: "FIELD(id,?)", Vars: []interface{}{[]int{1, 2, 3}}, WithoutParentheses: true},}).Find(&User{})
// SELECT * FROM users ORDER BY FIELD(id,1,2,3)
1

Related

New to Communities?

Join the community