Query Builder : remove an ORDER BY clause from a query ?

I don't believe there is, unless you're willing to reset the whole query ($this->db->reset_query()). You should probably consider delaying the addition of the ORDER BY clause until you can determine whether it should be included, rather than trying to remove it later in the code.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide