This topic contains 4 replies, has 2 voices, and was last updated by 
- Posts
I’m sending this again as I am not clear that my previous submission came through.
https://woocommerce-95173-726718.cloudwaysapps.com/
401 auth access is rawww / electric29
My client has woocommerce products with the following SKU’s
PB630
PB630a
PB630bSearch term ‘PB630’ turns up all variation results above
However They want search term ‘630’ to turn up all variation results also.
Search term ‘630’ only turns up product PB630.
Attached is the code of my settings, is there anything we can tweak for this behaviour to work?
Regards
Hi,
The problem is, that the index table engine is used, which does not support mid-word matches. Mid-word random matching triggers the non-indexed queries in MySQL as well as MariaDB (it’s a limitation of the database engines, not the plugin), thus the only way to make this work is to use the regular engine instead.
Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
Brilliant, thanks for the explanation, Ernest.
You cannot access this content. Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
You must be logged in to reply to this topic.