IT/SQL
10] 프로그래머스 이름에 el이 들어가는 동물 찾기
깻잎쌈
2020. 11. 7. 19:55
반응형
EL이 들어가는 DOG
SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE ANIMAL_TYPE = 'Dog' AND NAME LIKE '%el%'
ORDER BY NAME;
www.tutorialspoint.com/sql/sql-like-clause.htm
SQL - LIKE Clause - Tutorialspoint
SQL - LIKE Clause The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator. The percent sign (%) The underscore (_) The percent sign represents zero, one o
www.tutorialspoint.com
반응형