Lære LIKE filtering

Sometimes you need to filter by some non-numeric column, but not by exact value, but some pattern.

One of the clearest examples is filtering emails so only emails hosted on google will be left (@gmail.com). In SQL it can be done by using LIKE statement and pattern built by using some wildcards. The most common wildcards are:

% - represents zero, one or more symbols
_ - represents one, and only one symbol.

For example, pattern a% will match everything starting with a (even single symbol a), pattern _B will match only two-letters strings ending with B.

To solve the task above we can use pattern %@gmail.com, as there is usually more than one symbol before @ symbol, but we don't know the exact number.


              123
            
SELECT *
FROM visitors
WHERE email LIKE '%@gmail.com'

Please note, that you need to place your pattern within single quotes!

Opgave

Swipe to start coding

From the audi_cars table extract all the A-series cars (model starts with the letter A).

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 2. Kapitel 6

single

Spørg AI

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Sometimes you need to filter by some non-numeric column, but not by exact value, but some pattern.

% - represents zero, one or more symbols
_ - represents one, and only one symbol.

For example, pattern a% will match everything starting with a (even single symbol a), pattern _B will match only two-letters strings ending with B.

To solve the task above we can use pattern %@gmail.com, as there is usually more than one symbol before @ symbol, but we don't know the exact number.


              123
            
SELECT *
FROM visitors
WHERE email LIKE '%@gmail.com'

Please note, that you need to place your pattern within single quotes!

Opgave

Swipe to start coding

From the audi_cars table extract all the A-series cars (model starts with the letter A).

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 2. Kapitel 6

single

Stryg for at vise menuen

Sometimes you need to filter by some non-numeric column, but not by exact value, but some pattern.

% - represents zero, one or more symbols
_ - represents one, and only one symbol.

For example, pattern a% will match everything starting with a (even single symbol a), pattern _B will match only two-letters strings ending with B.

To solve the task above we can use pattern %@gmail.com, as there is usually more than one symbol before @ symbol, but we don't know the exact number.


              123
            
SELECT *
FROM visitors
WHERE email LIKE '%@gmail.com'

Please note, that you need to place your pattern within single quotes!

Opgave

Swipe to start coding

From the audi_cars table extract all the A-series cars (model starts with the letter A).

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

LIKE filtering

Løsning

Awesome!

LIKE filtering

Løsning

Awesome!

LIKE filtering

Løsning