我正在尝试对BuddyPress组进行自定义搜索。

Here is my method:

public function search_groups($string){
    global $wpdb;
    $results = $wpdb->get_results($wpdb->prepare(
        "
        SELECT * 
        FROM {$wpdb->prefix}bp_groups 
        WHERE `name` LIKE \'%%s%\'
        AND `description` LIKE \'%%s%\' 
        AND `status` = \'public\'
        ORDER BY `name` ASC
        ",
        $string,
        $string
    ));
    if(!empty($results)){
        $return = $results;
    } else{
        $return = false;    
    }
    return $return;
}

但是，我收到WordPress数据库错误。我很确定这是因为我$wpdb->prepare();, 因为它使用%符号替换变量。

Let\'s take a look at this portion of my query:

WHERE `name` LIKE \'%%s%\'
AND `description` LIKE \'%%s%\'

这看起来很麻烦。有没有什么方法可以让我按照……的思路完成一些事情。。。

WHERE `name` LIKE \'%{$string}%\'
AND `description` LIKE \'%{$string}%\'

并且仍然使用$wpdb->prepare(); 方法

SELECT * 
FROM {$wpdb->prefix}bp_groups 
WHERE `name` LIKE \'%%%s%%\'
OR `description` LIKE \'%%%s%%\' 
AND `status` = \'public\'
ORDER BY `name` ASC

global $wpdb;
$wpdb->query( $wpdb->prepare(
    \'DELETE FROM %s WHERE `option_name` LIKE %s\',
    $wpdb->options,
    $wpdb->esc_like(PLUGIN_SLUG . \'%%\')
) );