function __adapted_search_function($search, $query) {
if (is_admin() || !$query->is_main_query() || !$query->is_search) {
return;
}
global $wpdb;
$search_term = $query->get('s');
$search = " AND (";
$search .= "({$wpdb->posts}.post_title LIKE '%$search_term%')";
$search .= " OR ";
$search .= "({$wpdb->posts}.post_excerpt LIKE '%$search_term%')";
$search .= " OR ";
$search .= "({$wpdb->postmeta}.meta_key = 'findergg' AND $wpdb->postmeta.meta_value LIKE '%$search_term%')";
$search .= ") ";
add_filter("posts_join", '__custom_join_tables');
add_filter('posts_where', 'posts_where');
add_filter('posts_fields', 'custom_posts_fields');
return $search;
}
function posts_where($where) {
global $wpdb;
$where = " ";
return $where;
}
function __custom_join_tables($joins) {
global $wpdb;
$joins .= " JOIN $wpdb->postmeta AS wpma ON (wpma.post_ID = {$wpdb->posts}.ID) AND {$wpdb->posts}.post_status = 'publish' AND wpma.meta_value LIKE '%Sunt expedita%' ";
return $joins;
}
function custom_posts_fields($fields) {
global $wpdb;
$fields = " {$wpdb->posts}.post_title, {$wpdb->posts}.post_content ";
return $fields;
}
add_action('posts_search', '__adapted_search_function', 1, 2);ima
Test:
Kết quả sql
SELECT wp_posts.post_title, wp_posts.post_content FROM wp_posts JOIN wp_postmeta AS wpma ON (wpma.post_ID = wp_posts.ID)
AND wp_posts.post_status = 'publish'
AND wpma.meta_value LIKE '%Sunt expedita%' WHERE 1=1
ORDER BY (CASE WHEN wp_posts.post_title LIKE '{test8}perspiciatis laboriosam{test8}' THEN 1 WHEN wp_posts.post_title LIKE '{test8}perspiciatis{test8}' AND wp_posts.post_title LIKE '{test8}laboriosam{test8}' THEN 2 WHEN wp_posts.post_title LIKE '{test8}perspiciatis{test8}' OR wp_posts.post_title LIKE '{test8}laboriosam{test8}' THEN 3 WHEN wp_posts.post_excerpt LIKE '{test8}perspiciatis laboriosam{test8}' THEN 4 WHEN wp_posts.post_content LIKE '{test8}perspiciatis laboriosam{test8}' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10
Chú ý:
Kết quả sql:
Chú ý: Nếu thêm điều kiện này thì thật hoàn hảo
$where = " AND {$wpdb->posts}.post_status = 'publish' ";
Chú ý: Tôi lại thêm một điều kiện vào where để xem
