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).
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
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).
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
single
Awesome!
Completion rate improved to 2.63LIKE filtering
Pyyhkäise näyttääksesi valikon
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).
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
