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.
123SELECT * FROM visitors WHERE email LIKE '%@gmail.com'
Please note, that you need to place your pattern within single quotes!
Swipe to start coding
From the audi_cars table extract all the A-series cars (model starts with the letter A).
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63LIKE 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.
123SELECT * FROM visitors WHERE email LIKE '%@gmail.com'
Please note, that you need to place your pattern within single quotes!
Swipe to start coding
From the audi_cars table extract all the A-series cars (model starts with the letter A).
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
single
Awesome!
Completion rate improved to 2.63LIKE filtering
Veeg om het menu te tonen
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.
123SELECT * FROM visitors WHERE email LIKE '%@gmail.com'
Please note, that you need to place your pattern within single quotes!
Swipe to start coding
From the audi_cars table extract all the A-series cars (model starts with the letter A).
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
