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%
matchesa
,aa
,aaaaa
, etc.b%d
matchesbd
,bad
,bored
, etc._
matches single symbol.t_ee
matchestree
,twee
etc, and_o%_
matchwow
,coooow
,soap
etc., but notso
for example.
In this example all singers with the naming of two separate words, both consist of at least one symbol.
12SELECT singer FROM songs WHERE singer LIKE '_% _%'
Swipe to start coding
Select all singer
s with naming starting with A.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Resumir este capítulo
Explicar el código en file
Explicar por qué file no resuelve la tarea
Awesome!
Completion rate improved to 4.17
SQL Like
Desliza para mostrar el menú
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%
matchesa
,aa
,aaaaa
, etc.b%d
matchesbd
,bad
,bored
, etc._
matches single symbol.t_ee
matchestree
,twee
etc, and_o%_
matchwow
,coooow
,soap
etc., but notso
for example.
In this example all singers with the naming of two separate words, both consist of at least one symbol.
12SELECT singer FROM songs WHERE singer LIKE '_% _%'
Swipe to start coding
Select all singer
s with naming starting with A.
Solución
¡Gracias por tus comentarios!
Awesome!
Completion rate improved to 4.17single