SELECT * FROM (`DB_TABLE`) WHERE `colour` IN ('\'D\','\'E\',\'F\'')
$colour = array('D', 'E', 'F'); $this->db->where_in('colour', $colour); $query = $this->db->get('DB_TABLE'); echo $this->db->last_query();