LIKE, IN and BETWEEN · LIKE, IN y BETWEEN
Matching text patterns with LIKE
= only matches text exactly. To match a pattern, use LIKE with two wildcards:
%stands for any run of characters (including none)_stands for exactly one character
'S%' means "starts with S". '%a%' means "contains an a". '_o%' means "an o as the second letter".
Coincidir patrones de texto con LIKE
= solo coincide con texto exactamente. Para coincidir con un patrón, use LIKE con dos comodines:
%representa cualquier secuencia de caracteres (incluyendo ninguna)_representa exactamente un carácter
SELECT name FROM student WHERE name LIKE 'S%';
'S%' significa "comienza con S". '%a%' significa "contiene una a". '_o%' significa "una o como segunda letra".
Lists and ranges: IN and BETWEEN
Two more handy tests:
IN (…)matches any value in a list:WHERE form IN ('11A', '11C')BETWEEN low AND highmatches a range, including both ends:
Both are shorter than writing several ORs.
Listas y rangos: IN y BETWEEN
Dos pruebas más útiles:
IN (…)coincide con cualquier valor en una lista:WHERE form IN ('11A', '11C')BETWEEN low AND highcoincide con un rango, incluyendo ambos extremos:
SELECT name, score FROM student WHERE score BETWEEN 70 AND 90;
Ambas son más breves que escribir varias condiciones OR.
Common mistakes
- In
LIKE,%matches any text:'A%'means "starts with A". BETWEEN a AND bincludes both ends.
Errores comunes
- En
LIKE,%coincide con cualquier texto:'A%'significa "comienza con A". BETWEEN a AND bincluye ambos extremos.
Pattern & range filters · Filtros de patrón y rango
LIKE / IN / BETWEEN are all WHERE · DONDE — they keep matching rows. · LIKE / IN / BETWEEN son todos WHERE · DONDE — mantienen las filas coincidentes.
Show the name of every student whose name contains the letter a. Use LIKE with %. · Muestra el name de cada estudiante cuyo nombre contenga la letra a. Usa LIKE con %.
Click Run to see the output here. · Haz clic en Ejecutar para ver la salida aquí.
Show the name and · y score of students whose score is between 70 and 90 (inclusive). Use BETWEEN. · Muestra el name y score de los estudiantes cuya puntuación esté entre 70 y 90 (inclusive). Usa BETWEEN.
Click Run to see the output here. · Haz clic en Ejecutar para ver la salida aquí.