NOT like this!
Often situation when we know what we don't want to find. In the case of numeric value, you should already know, that there is <> sign in SQL which means not equal. This also works for non-numeric columns: you can easily set <> 'some word' condition. But what if we want to avoid multiple non-numeric values? Or avoid some pattern?
Of course, it's already solved! There is NOT statement in SQL, which can be used with LIKE and IN statements. For example, we can filter cars in audi_table so there won't be Q-series cars.
123SELECT * FROM audi_cars WHERE model NOT LIKE 'Q%'
Please note, that
NOTshould be placed beforeINorLIKE, like in spelling.
Swipe to start coding
Extract all the cars from the audi_cars table except A3, A4, and Q3 models.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63NOT like this!
Often situation when we know what we don't want to find. In the case of numeric value, you should already know, that there is <> sign in SQL which means not equal. This also works for non-numeric columns: you can easily set <> 'some word' condition. But what if we want to avoid multiple non-numeric values? Or avoid some pattern?
Of course, it's already solved! There is NOT statement in SQL, which can be used with LIKE and IN statements. For example, we can filter cars in audi_table so there won't be Q-series cars.
123SELECT * FROM audi_cars WHERE model NOT LIKE 'Q%'
Please note, that
NOTshould be placed beforeINorLIKE, like in spelling.
Swipe to start coding
Extract all the cars from the audi_cars table except A3, A4, and Q3 models.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
single
Awesome!
Completion rate improved to 2.63NOT like this!
Sveip for å vise menyen
Often situation when we know what we don't want to find. In the case of numeric value, you should already know, that there is <> sign in SQL which means not equal. This also works for non-numeric columns: you can easily set <> 'some word' condition. But what if we want to avoid multiple non-numeric values? Or avoid some pattern?
Of course, it's already solved! There is NOT statement in SQL, which can be used with LIKE and IN statements. For example, we can filter cars in audi_table so there won't be Q-series cars.
123SELECT * FROM audi_cars WHERE model NOT LIKE 'Q%'
Please note, that
NOTshould be placed beforeINorLIKE, like in spelling.
Swipe to start coding
Extract all the cars from the audi_cars table except A3, A4, and Q3 models.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
