Magento Commerce, 1.14.x

Magento 1.x Software Support Notice
For Magento Commerce 1, Magento is providing software support through June 2020. Depending on your Magento Commerce 1 version, software support may include both quality fixes and security patches. Please review our Magento Software Lifecycle Policy to see how your version of Magento Commerce 1 is supported.

MySQL Search

By adjusting the Catalog Search configuration, you can control the behavior of the search operations and determine the size of valid query text, and the display of search recommendations.

To configure catalog search:

1. On the Admin menu, select System > Configuration.
2. In the Configuration panel on the left, under Catalog, select Catalog. Then, click to expand the Catalog Search section.
Catalog Search (using MySql Fulltext)
Catalog Search (MySQL Fulltext)
3. To limit the length and word count of search query text, do the following:
a. Set Minimal Query Length to the minimum number of characters that can be submitted in a query.
b. Set Maximum Query Length to the maximum number of characters that can be submitted in a query.
c. Set Maximum Query Words Count to the maximum number of words that can be submitted in a query.
4. Accept the default Search Engine, “MySql Fulltext.”
5. Set Search Type to one of the following:
  • Like

    To perform a search based on individual keywords.


    To perform a search based on the full text of each attribute, ranked by relevance.

    Combine (Like and Fulltext)

    To perform a search based on a combination of the two types, matching keywords and taking relevance into consideration.

6. To limit the number of records that can be used with layered navigation, enter the maximum number allowed in the Apply Layered Navigation if Search Results are Less Than field. To allow any number of records, enter 0.
7. To display related search terms as recommendations, set Enable Search Recommendations to “Yes.” Then, do the following:
a. In the Search Recommendations Count field, enter the maximum number of recommendations displayed for a search.
b. To show the number of recommendations per term in parentheses after the recommendation, set Show Results Count for each Recommendation to “Yes.”
8. When complete, click the Save Config button.