Multiple Keyword search is not working

I am using v1.5.10 and there is problem of Multiple Keyword search not working. Especially in adding new product.

Say for ex. If i have a product named “Test Product”. When i search with the keyword test it works fine. If i use test p or test product, when it comes to multiple words it doesn’t work.

       $this->db->group_start();
      
       // tried this
        $str = str_replace(" ","|", $match);
        $this->db->where("ip_products.product_name rlike '$str'");

        $this->db->or_like('ip_products.product_sku', $match);
        $this->db->or_like('ip_products.product_name', $match);
        
        $this->db->or_like('ip_products.product_description', $match);
        $this->db->group_end();
   
        // then this
        $this->db->group_start();
        $this->db->like('ip_products.product_name', $match);
        $this->db->or_where('ip_products.product_sku', $match);
        $this->db->or_where('ip_products.product_description', $match);
       $this->db->group_end();

       // then this too
        $str = str_replace(" ","|", $match);
        $str = explode(" ", $match);
        $this->db->where("ip_products.product_name rlike '$str'");

Nothing worked for me.

even i tried this too

        $this->db->group_start();
        $this->db->select('*');
        $this->db->from('ip_products');
        $this->db->like('ip_products.product_sku', $match);
        $this->db->or_like('ip_products.product_name', $match);
        $this->db->or_like('ip_products.product_description', $match, 'both');
        $this->db->or_like('ip_products.product_description', $match, 'before');
        $this->db->or_like('ip_products.product_description', $match, 'after');*/
        $this->db->group_end();

I’ll try to take a look this evening. It’s been a while since I’ve tested the product search/lookup.

i have fixed that i have been once a contributor once #kovah was there.

If required let me know how i should share the #fix

Please send a link to the fix for the multiple keyword search in the product field.

Feel free to open a PR and contribute your fix/code to the project