1$this->db->order_by('title', 'DESC');
2// Produces: ORDER BY `title` DESC
3
1$names = array('Frank', 'Todd', 'James');
2$this->db->where_not_in('username', $names);
3// Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')
4
1$this->db->like('title', 'match'); $this->db->or_like('body', $match);
2// WHERE `title` LIKE '%match%' ESCAPE '!' OR `body` LIKE '%match%' ESCAPE '!'
3
1$this->db->order_by('RegisteredUserID','ASC')
2// Produces: ORDER BY `RegisteredUserID` ASC
3
4$this->db->order_by('RegisteredUserID','DESC')
5// Produces: ORDER BY `RegisteredUserID` DESC