Is it possible to get below result in SQL Server with single query?!
example data [description_column]:
- LG television
- BOSCH vacuum cleaner 55 mm
- SONY home theater 55 watt
String to search: LG 55 vacuum theater home
UPDATE: I wanna order result according to words count in search term, so desired result is as below:
- SONY home theater 55 watt (contains three words: 55,theater, home)
- BOSCH vacuum cleaner 55 mm (contains two words: 55,vacuum)
- LG television (contains one word: LG)
Thanks in advance
See Question&Answers more detail:os