d19cannon

It works! You’re an absolute life saver.
Thank you for you help ??

I did and I added the following in functions.php

add_filter("relevanssi_fuzzy_query", "rlv_partial_inside_words");
function rlv_partial_inside_words($query) {
    return "(term LIKE '%#term#%')"; 
}

Without success

• This reply was modified 4 years, 5 months ago by d19cannon.

Yeah, I understand that the length should be greater than 1, however, I am trying to get any other alternative results.

Thank you for you input! I will keep you posted about the results.

Quick update how the query looks like

string(714) "SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 +
				relevanssi.content * 5 + relevanssi.comment * 0.75 +
				relevanssi.tag * 1 + relevanssi.link * 0.75 +
				relevanssi.author + relevanssi.category * 1 + relevanssi.excerpt +
				relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
				FROM wp_relevanssi AS relevanssi  WHERE  relevanssi.term = '45'   AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID) FROM wp_posts AS posts
			WHERE posts.post_type NOT IN ('revision', 'nav_menu_item', 'custom_css', 'customize_changeset', 'oembed_cache', 'user_request', 'acf-field-group', 'acf-field', 'smart-services', 'archive', 'faq'))) OR (doc = -1)) ORDER BY tf DESC LIMIT 500"