Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lära SQL Like | Filtering Statements
SQL Tutorial for Beginners
course content

Kursinnehåll

SQL Tutorial for Beginners

SQL Tutorial for Beginners

1. Database & Introduction to Syntax
Meet the SQLSelect the Songs!SQL Select ColumnSQL DistinctSQL WhereChallenge WhereSQL And, Or, Not
2. SQL Aggregate Functions
SQL Min and MaxChallenge Min and MaxSQL Count, Sum, AvgChallenge Count
3. Filtering Statements
SQL NullSQL LikeChallenge LikeSQL BetweenSQL Order ByChallenge Order BySQL Group ByChallenge Group BySQL Top and LimitSQL AliasesSQL HavingChallenge HavingSQL Comments

book
SQL Like

The LIKE operator is used with WHERE to search for some pattern in a string.

The pattern is usually some kind of Regular Expression that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

  • % means 0 or more symbols: a% matches a, aa, aaaaa, etc. b%d matches bd, bad, bored, etc.
  • _ matches single symbol. t_ee matches tree, twee etc, and _o%_ match wow, coooow, soap etc., but not so for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.


              
12

            
SELECT singer FROM songs
WHERE singer LIKE '_% _%'
copy
Uppgift

Swipe to start coding

Select all singers with naming starting with A.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 3. Kapitel 2
toggle bottom row

book
SQL Like

The LIKE operator is used with WHERE to search for some pattern in a string.

The pattern is usually some kind of Regular Expression that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

  • % means 0 or more symbols: a% matches a, aa, aaaaa, etc. b%d matches bd, bad, bored, etc.
  • _ matches single symbol. t_ee matches tree, twee etc, and _o%_ match wow, coooow, soap etc., but not so for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.


              
12

            
SELECT singer FROM songs
WHERE singer LIKE '_% _%'
copy
Uppgift

Swipe to start coding

Select all singers with naming starting with A.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 3. Kapitel 2
Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Vi beklagar att något gick fel. Vad hände?
some-alt