Programming/SQL

[MySQL] lv.2 ์ด๋ฆ„์— el์ด ๋“ค์–ด๊ฐ€๋Š” ๋™๋ฌผ ์ฐพ๊ธฐ | LIKE๋ฌธ ํ™œ์šฉ

ํ•ด๋“œ์œ„๊ทธ 2024. 2. 11. 15:49
๋ฐ˜์‘ํ˜•

๋ฌธ์ œ:

 

 

์ฝ”๋“œ:

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE ANIMAL_TYPE ='DOG'AND NAME LIKE '%EL%'
ORDER BY NAME

 

ํ’€์ด:

WHERE NAME = 'EL' ํ•˜๋ฉด ???๊ฐ€ ์ด๋ฆ„์ด ์ปฌ๋Ÿผ๋งŒ ๋‚˜์˜จ๋‹ค.

'EL'์ด ํฌํ•จ๋˜์–ด ์žˆ๋Š” ์ด๋ฆ„์„ ๊ฒ€์ƒ‰ํ•˜๋ ค๋ฉด LIKE๋ฅผ ์จ์•ผ๋œ๋‹ค.

 

NAME LIKE 'EL%' -> EL๋กœ ์‹œ์ž‘ํ•˜๋Š” ์ด๋ฆ„ ์ถœ๋ ฅ

NAME LIKE '%EL' -> EL๋กœ ๋๋‚˜๋Š” ์ด๋ฆ„ ์ถœ๋ ฅ

NAME LIKE '%EL%' -> EL์ด ํฌํ•จ๋˜์–ด ์žˆ๋Š” ์ด๋ฆ„ ์ถœ๋ ฅ

 

๋ฐ˜์‘ํ˜•