function search_gallery_by_title_content_tags($search, $wp_query) {
global $wpdb;
if (is_admin() || !$wp_query->is_search()) {
return $search;
}
$search_term = $wp_query->get('s');
if (!$search_term) {
return $search;
}
$search = $wpdb->prepare(
" AND (
{$wpdb->posts}.post_title LIKE %s
OR {$wpdb->posts}.post_content LIKE %s
OR {$wpdb->posts}.ID IN (
SELECT object_id
FROM {$wpdb->term_relationships}
INNER JOIN {$wpdb->term_taxonomy}
ON {$wpdb->term_relationships}.term_taxonomy_id = {$wpdb->term_taxonomy}.term_taxonomy_id
INNER JOIN {$wpdb->terms}
ON {$wpdb->term_taxonomy}.term_id = {$wpdb->terms}.term_id
WHERE {$wpdb->terms}.name LIKE %s
)
)",
'%' . $wpdb->esc_like($search_term) . '%',
'%' . $wpdb->esc_like($search_term) . '%',
'%' . $wpdb->esc_like($search_term) . '%'
);
return $search;
}
add_filter('posts_search', 'search_gallery_by_title_content_tags', 10, 2);
トップページ - Midnight Baby
