Filtrar texto
SQL intermedio
Jasmin Ludolf
Data Science Content Developer, DataCamp
Filtrar texto
WHEREtambién puede filtrar texto
SELECT title
FROM films
WHERE country = 'Japan';
|title |
|-----------------|
|Seven Samurai |
|Tora! Tora! Tora!|
|Akira |
|Madadayo |
|Street Fighter |
...
Filtrar texto
- Filtrar un patrón en lugar de un texto concreto
LIKENOT LIKEIN
LIKE
- Se utiliza para buscar un patrón en un campo
% coincide con cero, uno o muchos caracteres
SELECT name
FROM people
WHERE name LIKE 'Ade%';
|name |
|-------------|
|Adel Karam |
|Adelaide Kane|
|Aden Young |
_ coincide con un solo carácter
SELECT name
FROM people
WHERE name LIKE 'Ev_';
|name |
|-------------|
|Eve |
Ev_ Mendes
NOT LIKE
SELECT name
FROM people;
|name |
|------------------|
|50 Cent |
|A. Michael Baldwin|
|A. Raven Cruz |
|A.J. Buckley |
|A.J. DeLucia |
...
SELECT name
FROM people
WHERE name NOT LIKE 'A.%';
|name |
|-------------|
|50 Cent |
|Aaliyah |
|Aaron Ashmore|
|Aaron Hann |
...
Posición de comodín
SELECT name
FROM people
WHERE name LIKE '%r';
|name |
|---------------|
|A.J. Langer |
|Aaron Schneider|
|Aaron Seltzer |
|Abigail Spencer|
...
SELECT name
FROM people
WHERE name LIKE '__t%';
|name |
|-----------------------|
|Aitana Sánchez-Gijón |
|Anthony 'Critic' Campos|
|Anthony Bell |
|Anthony Burrell |
...
WHERE, OR
SELECT title
FROM films
WHERE release_year = 1920
OR release_year = 1930
OR release_year = 1940;
|title |
|------------------------------|
|Over the Hill to the Poorhouse|
|Hell's Angels |
|Boom Town |
...
WHERE, IN
SELECT title
FROM films
WHERE release_year IN (1920, 1930, 1940);
|title |
|------------------------------|
|Over the Hill to the Poorhouse|
|Hell's Angels |
|Boom Town |
...
WHERE, IN
SELECT title
FROM films
WHERE country IN ('Germany', 'France');
|title |
|-------------|
|Metropolis |
|Pandora's Box|
|The Train |
...
¡Vamos a practicar!
SQL intermedio
