如何为WP_Query设置meta_query与tax_query的OR关系

默认情况下，WP_Query的meta_query和tax_query是AND关系，即需同时满足两个条件才会返回结果。要实现OR逻辑（满足任一条件即可），需要通过posts_where过滤器修改SQL查询的WHERE子句，将两个条件的连接符从AND替换为OR。

修改后的完整代码（硬编码替换版） #

// 添加过滤器，替换WHERE子句中的AND为OR
add_filter('posts_where', 'meta_tax_or_where_clause');

$loop = new WP_Query(array( 
    'post_type' => 'tickets',
    'paged' => $paged,
    'order' => $order,
    'orderby' => $orderby,
    'meta_query' => array(
        array(
            'key' => 'tps_email',
            'value' => 'web@data.com',
            'compare' => 'LIKE',
        ),  
    ),  
    'tax_query' => array(
        array(
            'taxonomy' => 'topic',
            'field' => 'slug',
            'terms' => 'housekeeping',
        ),
    ),
));

// 移除过滤器，避免影响后续查询
remove_filter('posts_where', 'meta_tax_or_where_clause');

function meta_tax_or_where_clause($where) {
    // 替换meta查询和tax查询之间的AND为OR
    // 注意：需匹配实际生成的SQL片段，可开启WP_DEBUG查看原始SQL调整
    $where = str_replace(
        'AND (wp_postmeta.meta_key = \'tps_email\' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE \'%web@data.com%\')',
        'OR (wp_postmeta.meta_key = \'tps_email\' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE \'%web@data.com%\')',
        $where
    );
    return $where;
}

通用适配版代码 #

如果担心硬编码SQL片段出错，可以用更灵活的方式解析条件块再拼接：

add_filter('posts_where', 'meta_tax_or_where_clause_v2');

$loop = new WP_Query(array( 
    'post_type' => 'tickets',
    'paged' => $paged,
    'order' => $order,
    'orderby' => $orderby,
    'meta_query' => array(
        array(
            'key' => 'tps_email',
            'value' => 'web@data.com',
            'compare' => 'LIKE',
        ),  
    ),  
    'tax_query' => array(
        array(
            'taxonomy' => 'topic',
            'field' => 'slug',
            'terms' => 'housekeeping',
        ),
    ),
));

remove_filter('posts_where', 'meta_tax_or_where_clause_v2');

function meta_tax_or_where_clause_v2($where) {
    // 分割WHERE子句中的条件块
    $conditions = explode('AND', $where);
    $meta_condition = '';
    $tax_condition = '';
    $other_conditions = array();

    foreach ($conditions as $condition) {
        $trimmed = trim($condition);
        if (strpos($trimmed, 'wp_postmeta.meta_key = \'tps_email\'') !== false) {
            $meta_condition = $trimmed;
        } elseif (strpos($trimmed, 'wp_term_taxonomy.taxonomy = \'topic\'') !== false) {
            $tax_condition = $trimmed;
        } else {
            $other_conditions[] = $trimmed;
        }
    }

    // 重新拼接WHERE子句，将meta和tax条件用OR连接
    $new_where = implode(' AND ', $other_conditions);
    if ($meta_condition && $tax_condition) {
        $new_where .= ' AND (' . $meta_condition . ' OR ' . $tax_condition . ')';
    } elseif ($meta_condition) {
        $new_where .= ' AND ' . $meta_condition;
    } elseif ($tax_condition) {
        $new_where .= ' AND ' . $tax_condition;
    }

    return $new_where;
}

注意事项 #

• 如果你的数据库表前缀不是wp_，需要替换代码中对应的表前缀。
• 执行查询后必须移除过滤器，防止这个逻辑干扰后续的WP_Query查询。

内容的提问来源于stack exchange，提问作者Tarang koradiya