I want complete sorting like this with MySQL FIELD function.
SELECT id, name, priority FROM mytable ORDER BY FIELD(priority, "core")
but how can I do in fuel php ? query builder ?