search

SQL: Search query to get attachments only of those parents which are published

Well since nobody helped with at first look such an easy problem, i used my way, and if somebody will need it here it is: I used this query: $results = $wpdb->get_results( $wpdb->prepare( “select $wpdb->posts.ID, $wpdb->posts.post_status, $wpdb->posts.post_parent from $wpdb->posts where post_title like ‘%%%s%%’ and (post_type=”albumas” OR post_mime_type=”audio/mpeg”) AND (post_status=”inherit” OR post_status=”publish”) $excludes limit 0,”.$setting->limit, ($setting->search_content … Read more

Relevanssi show only 1 result

Try selecting “always” for fuzzy matches in the preferences. In the default setting, if search finds only 1 result, fuzzy matching won’t get activated.

Search functionality with multiple categories

Sounds like something Relevanssi could handle. With Relevanssi, you’d have the checkboxes to choose the categories. Then, you’d write a function to hook on ‘relevanssi_modify_wp_query’ filter, where you’d read the checkboxes and convert them to a comma-separated list of category ID’s. That you would store in $wp_query->query_vars[‘cats’] and hey presto, Relevanssi gives you relevant results … Read more

Make search result returned only from tags! [duplicate]

You can start with the Search Everything plugin and go from there. It won’t exclude all post title and content, but it will enable searching in tags. Perhaps you can see how they accomplish it and modify from there. I imagine it will entail some direct SQL manipulation via the query filters posts_where, posts_join, posts_request, … Read more

+ More