Level 122
you use a where statement
write some code for review...
Sep 23, 2020
5
Level 6
query order text
I have a $ table-> text ('status') field that can take cat, dog, rabbit, t-rex (it's just these 4) I would like to query that orders for rabbit, dog, t-rex, cat?
Level 6
clearly it must not be a lexicographical order. IF IT WERE an ENUM type field I would order like this:
$exampleEnum = DB::table('polls')->orderByRaw('FIELD(status, "rabbit", "dog","t-rex","cat")asc')->orderBy('created_at', 'asc')->get();
BUT the field is TEXT TYPE
Level 27
DB::table('animal')->where('status', 'rabbit')->get(); // this will get all the rabbits
Level 27
@gianmarx You already got it. What is not working?
Level 6
i noticed that orderByRaw also works on text
Please or to participate in this conversation.