d19cannon's Replies | ww.wp.xz.cn

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

Forum: Plugins
In reply to: [Relevanssi - A Better Search] Can’t match topics search with only digits

Thread Starter d19cannon
(@d19cannon)

6 years ago

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

Forum: Plugins
In reply to: [Relevanssi - A Better Search] Can’t match topics search with only digits
Thread Starter d19cannon
(@d19cannon)

6 years ago
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 6 years ago by d19cannon.
Forum: Plugins
In reply to: [Relevanssi - A Better Search] Can’t match topics search with only digits

Thread Starter d19cannon
(@d19cannon)

6 years ago

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.

Forum: Plugins
In reply to: [Relevanssi - A Better Search] Can’t match topics search with only digits
Thread Starter d19cannon
(@d19cannon)

6 years ago
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"
```

Viewing 4 replies - 1 through 4 (of 4 total)