How to pull data using Like and Not Like together? or can other optimal ways to search for words?
There is a table Items:
- Buy cable
- Install cable
Like this (but this is wrong, it gives both):
SELECT * FROM Items WHERE Description like '%кабель%' AND Description NOT Like'%установка%'
Result:
- Buy cable
I would be glad if you leave more useful links for the study)))
Description NOT Like'%установка%'is the same and done, change toDescription NOT Like'%установ%'and you will be happy. - Nick Proskuryakov