Query string using LIKE %$var% 1

[craigglenn]

Hi all,

I think this is pretty simple but I am new to PHP.

How do I alter this line to make my search with the wildcard % at the beginning and end of my variable. I am altering some existing code.

if(!empty($searchTerms))
{
$query .= $wpdb->prepare("AND company_name LIKE %s",$searchTerms);
}


Thanks in advance for the help.

Also as a bonus question can anyone tell me what the 's' is for in the %s?

Craig

"You can have anything in life you want if you help enough people get what they want"
Zig Ziggler

 

[jpadie]

if(!empty($searchTerms)) 
    {
        $query .= $wpdb->prepare("AND company_name LIKE %s",'%'.$searchTerms.'%');
    }

the %s tells printf and sprintf to substitute the term for a string. %d for a digit etc. check out the manual on printf() for all the available options.

the alternative is to use regexp rather than like. i doubt that for simple searches there is any advantage.

 

[craigglenn]

Thank you so much. This worked like a charm!

Plus thanks for the %s lesson!

Craig Glenn

"You can have anything in life you want if you help enough people get what they want"
Zig Ziggler