I want to order by type, by a pattern. Records now:
type name
1 a
2 b
1 c
4 d
4 e
3 f
2 g
3 h
my pattern is 2,4,3,1 so I would like to get:
2 b
2 g
4 d
4 e
3 f
3 h
1 a
1 c
Asked
Active
Viewed 667 times
0
John Smith
- 6,129
- 12
- 68
- 123
-
1try .. `order by field (type,2,4,3,1)` – Jens Jul 06 '16 at 11:32
-
what is this name? How is it called? Order by pattern? – John Smith Jul 06 '16 at 11:35
-
1Sorry did not get you. field is a string function: http://dev.mysql.com/doc/refman/5.7/en/string-functions.html – Jens Jul 06 '16 at 11:37
-
something like that: http://stackoverflow.com/questions/19867118/symfony2-createquery-order-by-field nevermind. Post your answer so that I can accept it – John Smith Jul 06 '16 at 11:49
