$this->db->orderby ?

[eluser]Christopher Blankenship[/eluser]
outtolunch truly there is no solution to your question.... SQL's ORDER BY does not work the way you are intending suggestion to look at the following : http://www.sql-tutorial.com/sql-order-by-sql-tutorial/

You are treating order by like a where clause. The only way to do what you are wanting is to separate the queries to return 1 query with those equal to brent then a second query to return those that are not equal to brent then merge the two returns together and return the result.

This is one way of doing it.

1. create a null array as a placeholder.
2. query 1.
3. query 2.
4. foreach result in query 1 add to the placeholder.
5. foreach result in query 2 add to the placeholder.
6. return placeholder.