All geek questions in one place

Keyword Search in SQL Server

I have a scenario where I need to search for cars by keywords using one search field. Keywords may refer to any of the attributes of a car, for example. brand or model or body style. The database has a table called "Car" with foreign keys that reference tables that represent models or make or body style.

What would be the best way to do this? In particular, how do I get a request from a user (it is necessary to maintain an exact search for a phrase, or, and) and how do I really perform a search.

I am using SQL Server and ASP.NET 3.5 (data access using LINQ)

+3
source share
2 answers

Easily the best and most comprehensive related article: http://www.sommarskog.se/dyn-search-2005.html

+12
source

No matter which implementation you choose from an Aaron article, I always record search criteria and lead time in this situation. Just because you provide search flexibility does not mean that most users will use it. You usually find that most queries occur on a limited number of fields, and registering your search criteria allows you to create target indexes.

+2
source

Source: https://habr.com/ru/post/1723297/

More articles:


All Articles