ActiveRecord - Order by alphabet first then follow by number

Question

Let's say I have a collection products with the following values for "name":

The following code:

@products.reorder('name ASC') # I really need to use reorder in my code

will list the results as-is:

What should I tweak in reorder() to have the following order:

https://stackoverflow.com/questions/17418215/order-by-alphabet-first-then-follow-by-number — Alex Baidan, Oct 13 '18 at 17:47
Yep I saw it, how do you convert that syntax to the active record? — Jeremie Ges, Oct 13 '18 at 18:10

Alex Baidan · Answer 1 · 2018-10-13T20:49:09.427

1

@products.reorder("(name ~ '^[0-9]'), name")

Explanation: FALSE sorts before TRUE so digit values will be last.

edited Oct 13 '18 at 20:49

answered Oct 13 '18 at 18:36

Alex Baidan

codenamev · Answer 2 · 2018-10-15T15:49:36.430

0

@products.reorder("(name !~* '^[a-z]'), name")

edited Oct 15 '18 at 15:49

answered Oct 13 '18 at 18:17

codenamev

What database are you using? – codenamev Oct 13 '18 at 18:20
I use Postgresql – Jeremie Ges Oct 13 '18 at 18:21
I updated my answer. `RLIKE` should work. I added another alternative regexp matcher – codenamev Oct 13 '18 at 19:02
```@products.to_sql => "SELECT \"products\".* FROM \"products\" WHERE \"products\".\"active\" = TRUE ORDER BY (name ~ '^[a-z]'), name"``` First result: "500g Dairy Free Hemp Chocolate" – Jeremie Ges Oct 13 '18 at 19:10
Ok, I was missing case-insensitive negated matching. As @Oleksii Baidan mentioned, `FALSE` sorts before `TRUE`. – codenamev Oct 15 '18 at 15:51

2 Answers2