magento 2 : catalog search with less than 3 characters The Next CEO of Stack OverflowWhy do special characters in search terms are processed as encoded characters (only on Production Server)?Catalog search gives me a blank pageSearch catalog with less than 3 charactersMagento 2 short search keywordsCatalog Search Sorting Broken With Umlauts / Special CharactersMagento 2 Catalog Search with HyphenEnable Search Suggestion option in Catalog SearchMagento 2 catalog search resultExtend Catalog Search IndexerMagento 2.1.9 Community Edition Catalog Search page not displaying results

Is a distribution that is normal, but highly skewed considered Gaussian?

Does increasing your ability score affect your main stat?

Unclear about dynamic binding

Is it convenient to ask the journal's editor for two additional days to complete a review?

0 rank tensor vs 1D vector

Domestic-to-international connection at Orlando (MCO)

Dominated convergence theorem - what sequence?

How to count occurrences of text in a file?

Running a General Election and the European Elections together

When you upcast Blindness/Deafness, do all targets suffer the same effect?

Is it ever safe to open a suspicious HTML file (e.g. email attachment)?

Make solar eclipses exceedingly rare, but still have new moons

Writing differences on a blackboard

Can MTA send mail via a relay without being told so?

Is French Guiana a (hard) EU border?

Why didn't Khan get resurrected in the Genesis Explosion?

Axiom Schema vs Axiom

Method for adding error messages to a dictionary given a key

Is micro rebar a better way to reinforce concrete than rebar?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

Math-accent symbol over parentheses enclosing accented symbol (amsmath)

A Man With a Stainless Steel Endoskeleton (like The Terminator) Fighting Cloaked Aliens Only He Can See

Does Germany produce more waste than the US?

Newlines in BSD sed vs gsed



magento 2 : catalog search with less than 3 characters



The Next CEO of Stack OverflowWhy do special characters in search terms are processed as encoded characters (only on Production Server)?Catalog search gives me a blank pageSearch catalog with less than 3 charactersMagento 2 short search keywordsCatalog Search Sorting Broken With Umlauts / Special CharactersMagento 2 Catalog Search with HyphenEnable Search Suggestion option in Catalog SearchMagento 2 catalog search resultExtend Catalog Search IndexerMagento 2.1.9 Community Edition Catalog Search page not displaying results










2















I am working on magento 2.1.3.



Is there any possibility to search with 2 characters using catalog search?



Now i can't able to search terms like tv.










share|improve this question
























  • Go to Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search

    – Ankit Shah
    Feb 22 '17 at 6:11











  • magestore.com/magento-2-tutorial/…

    – Ankit Shah
    Feb 22 '17 at 8:51















2















I am working on magento 2.1.3.



Is there any possibility to search with 2 characters using catalog search?



Now i can't able to search terms like tv.










share|improve this question
























  • Go to Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search

    – Ankit Shah
    Feb 22 '17 at 6:11











  • magestore.com/magento-2-tutorial/…

    – Ankit Shah
    Feb 22 '17 at 8:51













2












2








2


1






I am working on magento 2.1.3.



Is there any possibility to search with 2 characters using catalog search?



Now i can't able to search terms like tv.










share|improve this question
















I am working on magento 2.1.3.



Is there any possibility to search with 2 characters using catalog search?



Now i can't able to search terms like tv.







magento2 magento-2.1 search






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Feb 22 '17 at 6:26









Danny Nimmo

1,088918




1,088918










asked Feb 22 '17 at 6:05









Sudheesh K SurendranSudheesh K Surendran

105213




105213












  • Go to Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search

    – Ankit Shah
    Feb 22 '17 at 6:11











  • magestore.com/magento-2-tutorial/…

    – Ankit Shah
    Feb 22 '17 at 8:51

















  • Go to Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search

    – Ankit Shah
    Feb 22 '17 at 6:11











  • magestore.com/magento-2-tutorial/…

    – Ankit Shah
    Feb 22 '17 at 8:51
















Go to Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search

– Ankit Shah
Feb 22 '17 at 6:11





Go to Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search

– Ankit Shah
Feb 22 '17 at 6:11













magestore.com/magento-2-tutorial/…

– Ankit Shah
Feb 22 '17 at 8:51





magestore.com/magento-2-tutorial/…

– Ankit Shah
Feb 22 '17 at 8:51










2 Answers
2






active

oldest

votes


















3














I do not know your search engine, I suppose that you use Mysql.
It works out of the box with ElasticSearch.



Resolution :



First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search



The data indexed (catalogsearch_fulltext_scope1) looks like :



*************************** 1. row ***************************
entity_id: 45
attribute_id: 73
data_index: tv


The SQL query for 'tv' request:



SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000


If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :



http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html



So edit your my.cnf file, add these parameters :



ft_min_word_len = 1
innodb_ft_min_token_size = 1


Restart mysql



service mysql restart


Rebuild your index



bin/magento indexer:reindex


Then you will see your product on the search result page.






share|improve this answer























  • Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

    – Franck Garnier
    Nov 20 '18 at 8:44


















0














In my case i needed 'edit' this file:



vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php



There was a constant and ignore config from backend






share|improve this answer























    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "479"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161166%2fmagento-2-catalog-search-with-less-than-3-characters%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    3














    I do not know your search engine, I suppose that you use Mysql.
    It works out of the box with ElasticSearch.



    Resolution :



    First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search



    The data indexed (catalogsearch_fulltext_scope1) looks like :



    *************************** 1. row ***************************
    entity_id: 45
    attribute_id: 73
    data_index: tv


    The SQL query for 'tv' request:



    SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000


    If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :



    http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html



    So edit your my.cnf file, add these parameters :



    ft_min_word_len = 1
    innodb_ft_min_token_size = 1


    Restart mysql



    service mysql restart


    Rebuild your index



    bin/magento indexer:reindex


    Then you will see your product on the search result page.






    share|improve this answer























    • Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

      – Franck Garnier
      Nov 20 '18 at 8:44















    3














    I do not know your search engine, I suppose that you use Mysql.
    It works out of the box with ElasticSearch.



    Resolution :



    First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search



    The data indexed (catalogsearch_fulltext_scope1) looks like :



    *************************** 1. row ***************************
    entity_id: 45
    attribute_id: 73
    data_index: tv


    The SQL query for 'tv' request:



    SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000


    If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :



    http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html



    So edit your my.cnf file, add these parameters :



    ft_min_word_len = 1
    innodb_ft_min_token_size = 1


    Restart mysql



    service mysql restart


    Rebuild your index



    bin/magento indexer:reindex


    Then you will see your product on the search result page.






    share|improve this answer























    • Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

      – Franck Garnier
      Nov 20 '18 at 8:44













    3












    3








    3







    I do not know your search engine, I suppose that you use Mysql.
    It works out of the box with ElasticSearch.



    Resolution :



    First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search



    The data indexed (catalogsearch_fulltext_scope1) looks like :



    *************************** 1. row ***************************
    entity_id: 45
    attribute_id: 73
    data_index: tv


    The SQL query for 'tv' request:



    SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000


    If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :



    http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html



    So edit your my.cnf file, add these parameters :



    ft_min_word_len = 1
    innodb_ft_min_token_size = 1


    Restart mysql



    service mysql restart


    Rebuild your index



    bin/magento indexer:reindex


    Then you will see your product on the search result page.






    share|improve this answer













    I do not know your search engine, I suppose that you use Mysql.
    It works out of the box with ElasticSearch.



    Resolution :



    First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search



    The data indexed (catalogsearch_fulltext_scope1) looks like :



    *************************** 1. row ***************************
    entity_id: 45
    attribute_id: 73
    data_index: tv


    The SQL query for 'tv' request:



    SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000


    If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :



    http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html



    So edit your my.cnf file, add these parameters :



    ft_min_word_len = 1
    innodb_ft_min_token_size = 1


    Restart mysql



    service mysql restart


    Rebuild your index



    bin/magento indexer:reindex


    Then you will see your product on the search result page.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Feb 22 '17 at 8:11









    Franck GarnierFranck Garnier

    2,096926




    2,096926












    • Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

      – Franck Garnier
      Nov 20 '18 at 8:44

















    • Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

      – Franck Garnier
      Nov 20 '18 at 8:44
















    Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

    – Franck Garnier
    Nov 20 '18 at 8:44





    Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch

    – Franck Garnier
    Nov 20 '18 at 8:44













    0














    In my case i needed 'edit' this file:



    vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php



    There was a constant and ignore config from backend






    share|improve this answer



























      0














      In my case i needed 'edit' this file:



      vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php



      There was a constant and ignore config from backend






      share|improve this answer

























        0












        0








        0







        In my case i needed 'edit' this file:



        vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php



        There was a constant and ignore config from backend






        share|improve this answer













        In my case i needed 'edit' this file:



        vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php



        There was a constant and ignore config from backend







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 2 days ago









        MarcMarc

        1112




        1112



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161166%2fmagento-2-catalog-search-with-less-than-3-characters%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Sum ergo cogito? 1 nng

            419 nièngy_Soadمي 19bal1.5o_g

            Queiggey Chernihivv 9NnOo i Zw X QqKk LpB