order by with specific column values

[forwardever]

Hello,

what is the best way to sort results by column values.

MySQL example:
SELECT * FROM table ORDER BY FIELD(ID,1,5,4,3)

[henrywoody]

I don't think there is a built-in function for this (could be wrong though), but you can use custom ordering like this:

query := client.MyModel.Query()
query.Order(func (s *sql.Selector) {
	s.OrderExpr(sql.ExprFunc(func(b *sql.Builder) {
		b.WriteString("FIELD(")
		b.Ident(mymodel.FieldID)
		b.WriteString(", 1, 5, 4, 3)")
	}))
})

or if those values come from user input:

query := client.MyModel.Query()
query.Order(func (s *sql.Selector) {
	s.OrderExpr(sql.ExprFunc(func(b *sql.Builder) {
		b.WriteString("FIELD(")
		b.Ident(mymodel.FieldID)
		for _, value := range values {
			b.WriteString(", ")
			b.Arg(value)
		}
		b.WriteString(")")
	}))
})