Search results 100% matching.

  • Resolved itboss

    (@itboss)


    6 years, 9 months ago

    Hello. Thank you for creating a convenient and free plug-in. Please help.
    I have 3 names.
    1112
    1113
    1111

    If I specify in search 1
    the result is the display of each of the three names, since each name contains 1.

    To solve my problem, I need to check the query for 100% matching names.
    for example

    I entered in the search 1, the search result: “Your number will not find”

    I entered into the search 112, the search result: “Your number will not find”

    I entered in the search 1112, the search result: “Your number is specified correctly”

    If you have time, please tell me the solution.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jeroen Peters

    (@jeroenpeters1986)

    Hi @itboss,

    thanks for using my plugin and contacting me. I had a few days off, and I did not spend them behind the computer.

    I see what you are trying to achieve. A lot of people will find this very inconvenient. You can change this behavior in your own installation if you want to.

    In helpers.php, you can change:

    
$sql_filter .= " AND (<code>name</code>LIKE '%" . $name_filter['containing'] . "%' OR <code>description</code>LIKE '%" . $name_filter['containing'] . "%') ";

    to 

    
$sql_filter .= " AND (<code>name</code>= '" . $name_filter['containing'] . "' OR<code>description</code>= '" . $name_filter['containing'] . "') ";

    I think that will help you solve this.

    Please let me know if this works for you. Would you also like to leave me a review?

    Kind regards,

    Jeroen Peters

    • This reply was modified 6 years, 9 months ago by Jeroen Peters.
    Plugin Author Jeroen Peters

    (@jeroenpeters1986)

    Hi @itboss,

    could you please let me know if this worked for you?

    Kind regards,

    Jeroen Peters

    Thread Starter itboss

    (@itboss)

    Hello Thank you very much, you helped me a lot.

    Plugin Author Jeroen Peters

    (@jeroenpeters1986)

    Hey @itboss, great to hear!
    If you like the plugin and/or my support, would you consider leaving a review?

    All the best,
    Jeroen Peters

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Search results 100% matching.’ is closed to new replies.