How to show all the products on search result page in Magento 2?

Question

I'm getting strange results from the search engine. For instance on "sk4072" if you search "4072" nothing comes up.

Thankyou

Answer 1

First, check or adjust the search settings as per your need.

Few suggestions:-

1. To have your product on the search results page, its Visibility setting must be Catalog, Search
2. Adjust the Marketing > Search Terms.
3. Enable Search Suggestions to Yes
4. Make sure products are added to the current store and website.
5. Mostly I add all the products to root category as well

For more info Mysql Search settings

Weighted Search:- Weight to give them a higher value in search results.Means you can give priority of one attribute to other Search Weight to a number from 1 to 10

Magento 2.x doesn't have %like% keyword of search.