In a web application that I write on asp.net mvc 5, you need to implement full-text search. I have a table of instructions in the database, in which there are other tables - category , tags , steps . In the table of steps there is a table of blocks . In the search box, I have to enter some string and the output should be instructions. This string can be in a category, in blocks, anywhere. Tell me what you need to use. And if not difficult, a link to some example.

Thanks in advance for your responsiveness and attention)

  • Which DBMS do you use? Most have full-text search support. Just turn it on and use it. For example, in SqlServer component Full-text Search . - Alexander Petrov
  • If the used DBMS does not have a built-in full-text search, then you can use any fulltext search engine. For example, the engine Lucene. See here . - Alexander Petrov

0