How to only have search results show up that exactly match?

I’d definitely appreciate a response here, please.

I guess the support is dead here :/

try this… it works for me
https://www.ads-software.com/support/topic/search-only-one-column-1/

@epwcsysh thank you for the response! I don’t think that is what I was looking for, however, I Have modified the code myself to get the desired results. Here is how to do it, in case someone stumbles on this plugin, loves it, but is disappointed that support is dead.

The situation is this: I have a database lookup system. I want people to be able to pull up exactly one result, based upon the serial number they pull up. I wanted ONLY ONE result each time someone searches something, so here goes:

Open up sds-main.php and on line 1441, change

$results_sql = “SELECT id,field_id,field_input FROM ” . $table . ” WHERE field_input COLLATE UTF8_GENERAL_CI LIKE ‘” . $_POST[‘sds-search-data’] . “%’ ORDER BY id ASC”;

to

$results_sql = “SELECT id,field_id,field_input FROM ” . $table . ” WHERE field_input COLLATE UTF8_GENERAL_CI LIKE ‘” . $_POST[‘sds-search-data’] . “%’ ORDER BY id ASC limit 1”;

That limits it just fine for me, and the desired results are achieved. I hope this helps someone here.

@epwcsysh I checked out the link you posted, and it looks like that solution works as well … and is probably better suited for what I need ?? My solution above may work best for folks who have several fields, but just to re-iterate what is needed: If you want to only have an exact match show up, simply crack open sds-main.php, and remove the % sign from lines 1441 and 1527.

Thanks Mouschi! Your post helped me!