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).
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
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).
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
Awesome!
Completion rate improved to 2.63LIKE filtering
Deslize para mostrar o menu
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).
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
