[eluser]Musaddiq Khan[/eluser]
Hi,
I want to generate SQL query through codeigniter function.
I have code as below.
Code:
$this->db->distinct();
$this->db->or_like('item.Model_Name',trim($search_key));
$this->db->or_like('item.Name',trim($search_key));
$this->db->or_like('item.sku_no',trim($search_key));
$this->db->or_like('item.SKU',trim($search_key));
$this->db->where('item.Is_Item <> ',0);
$this->db->where('item.Status','1');
$this->db->select('pkItemId,item.Name');
$this->db->limit($limit,$offset);
return $this->db->get('items')->result_array();
which generate the following query
Code:
SELECT DISTINCT `pkItemId`, `item`.`Name` FROM (`items`) WHERE `item`.`Is_Item` <> 0 AND `item`.`Status` = '1' AND `item`.`Model_Name` LIKE '%S1S38R%' OR `item`.`Name` LIKE '%S1S38R%' OR `item`.`sku_no` LIKE '%S1S38R%' OR `item`.`SKU` LIKE '%S1S38R%'
But I want that the OR clauses should be grouped as below.
Code:
SELECT DISTINCT `pkItemId`, `item`.`Name` FROM (`items`) WHERE `item`.`Is_Item` <> 0 AND `item`.`Status` = '1' AND (`item`.`Model_Name` LIKE '%S1S38R%' OR `item`.`Name` LIKE '%S1S38R%' OR `item`.`sku_no` LIKE '%S1S38R%' OR `item`.`SKU` LIKE '%S1S38R%')