clear select

Hi folks,
Using CI3
is there a way to clear / flush the select array ?

heres a basic example to try and explain better

PHP Code:

$this->db->select('user.*');


if ($rs_type == 'small_select'){

// clear the select options and start again
 $this->db->select('user.user_id'); // need to only select single item

 $query = $this->db->get('users');
 $result = $query->result();
 
 } else {

 // here we select everything as normal

 $query = $this->db->get('users');
 $result = $query->result();

 } 


thanks in advance

There is a 

PHP Code:

$this->db->reset_query() 


What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

would this not clear the whole query though rather than just the select element ?

would this not clear the whole query though rather than just the select element ?

PHP Code:

<?php
// Not tested but i would go for something like this
$select = ( null !== $rs_type && 'small_select' == $rs_type ) ? 'user.user_id' : 'user.*';
$query  = $this->db->select($select)->get('users');

$result = $query->result();