I have a query using active records.
$this->db->select('reg.users_id,reg.registration_id,reg.device_type');
$this->db->join('users as usr','usr.users_id = reg.users_id','left');
$this->db->where('usr.users_status',1);
$this->db->where('reg.users_id',91);
$query = $this->db->get('users_gcm_registration as reg');
I want to fetch DISTINCT(registration_id)
.
How can I do that?
$query = $this->db->select('registration_id')
->distinct('registration_id')
->from('reg')
->get();
return $query->result();
You can use distinct as
$this->db->distinct('reg.registration_id');
$this->db->select('reg.users_id,reg.device_type');
....
But better use group_by
$this->db->select('reg.users_id,reg.registration_id,reg.device_type');
$this->db->join('users as usr','usr.users_id = reg.users_id','left');
$this->db->where('usr.users_status',1);
$this->db->where('reg.users_id',91);
$this->db->group_by('reg.registration_id');// add group_by
$query = $this->db->get('users_gcm_registration as reg');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With