Hi,

I had a client point something out I never really thought about.

A product called "SALA Ultra-Lok" is in the database. If you search "sala ultra-lok", or "sala", or "ultra-lok", etc, no problems it is found.
But if you search "sala ultra lok" (or any variation without the hyphen), it will not be found.

I've fixed it with this:
PHP Code:
$strings explode(" "$search);
            foreach(
$strings as $key => $value){
                
                
$q .= 
                    AND (
                        p.productTitle LIKE '%"
.$this->escape_string($value)."%' OR
                        p.productSKU LIKE '%"
.$this->escape_string($value)."%' OR 
                        b.brandName LIKE '%"
.$this->escape_string($value)."%'
                    )"
;
                    
            } 
Is this right? Or is there a better way?

Cheers,
Rhys