What search technology is used?

Question

Search engines

It is necessary to organize a search in the database, but with multiple input of values ​​in the search string to further exclude the found values ​​from the search. I found an example on the site eda, ru when you click on "Ingredients, details" a selector comes out and it has two fields that interest me, "include ingredients" and "exclude ingredients", there when you type smart search hints appear, but when you click for the required ingredient, it is added to the field and you can add a few more. This is exactly what interests me. I checked the Internet and couldn't figure out how it was done, BuidWith didn't really help.

Answer 1

Tip: Be careful with your question.
In the meantime, I'll play wang. Let's assume that you are using MySQL as your database.
After WHERE, use IN and NOT IN predicates with sets.
Link to manual.

Answer 2

Q. How to build a DBMS and search on it?
A. Search: СУБД рецепты ингредиенты
Q. How do I search for "include ingredients" and "exclude ingredients"?
A.

SELECT наименование FROM ингредиенты
WHERE наименование IN ('морковь', 'картофель') AND наименование NOT IN ('сахар', 'мука')

Q. How to build a user interface?
A. Search:tutorial angular react Flutter