How to pull data using Like and Not Like together? or can other optimal ways to search for words?

There is a table Items:

  1. Buy cable
  2. Install cable

Like this (but this is wrong, it gives both):

SELECT * FROM Items WHERE Description like '%кабель%' AND Description NOT Like'%установка%'

Result:

  1. Buy cable

I would be glad if you leave more useful links for the study)))

  • It’s wrong here because Description NOT Like'%установка%' is the same and done, change to Description NOT Like'%установ%' and you will be happy. - Nick Proskuryakov
  • @NickProskuryako, output both: | - Shuhratjan Nizamov
  • one
    But is COLLATION not accidentally case-sensitive? - Akina
  • Look towards full-text search - docs.microsoft.com/ru-ru/sql/relational-databases/search/… - Yaant
  • @Akina, I don’t know, it seems not) - Shuhratjan Nizamov

0