CodeIgniter SELECT query to find qualifying combinations of values in two specified columns
I have checked other questions regarding this, but could not resolve issue
$this->db->where(array('sender_deletedS' => 1, 'receiver_deleted' => 0 ));
$this->db->or_where(array('sender_deletedS' => 0, 'receiver_deleted' => 1 ));
$this->db->or_where(array('sender_deletedS' => 0, 'receiver_deleted' => 0 ));
$query2 = $this->db->get('message');
It produces
SELECT *
FROM `message`
WHERE `sender_deletedS` = 1
AND `receiver_deleted` = 0
OR `sender_deletedS` = 0
OR `receiver_deleted` = 1
OR `sender_deletedS` = 0
OR `receiver_deleted` = 0
but I want this
SELECT *
FROM `message`
WHERE (`sender_deletedS` = 1 AND `receiver_deleted` =0)
OR (`sender_deletedS` =0 AND `receiver_deleted` = 1)
OR (`sender_deletedS` =0 AND `receiver_deleted` =0)