Sort a rails query based on array order

Question

I want to sort an ActiveRecord query based on the values in an array. Something like:

@fruits=Fruit.where(seeds: true)._________________________

Say I wanted to sort the results by color using the array ['Red','Blue','Yellow']

I see where SQL supports the use of a case statement for custom ordering, does Rails have something that utilizes this?

I doubt it, you'll probably have to use a bit of custom SQL with this: stackoverflow.com/a/9475755/2076787 or MySQL's FIELD. — D-side
– D-side, Commented Dec 3, 2014 at 16:13

kddeisz · Accepted Answer · 2014-12-03 16:21:22Z

3

If you're using MySQL, you can use FIELD. It would look like:

@fruit = Fruit.where(seeds: true).order("FIELD(color, 'Red', 'Blue', 'Yellow')")

answered Dec 3, 2014 at 16:21

kddeisz

5,2123 gold badges24 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

(Assuming the color column is called color)