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

๋ฌธ์ œ: ์ฝ”๋“œ: 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์ด ํฌํ•จ๋˜์–ด ์žˆ๋Š” ์ด๋ฆ„ ์ถœ๋ ฅ
Programming/SQL 2024. 2. 11. 15:49
1
๊ณต์ง€์‚ฌํ•ญ
์ตœ๊ทผ์— ์˜ฌ๋ผ์˜จ ๊ธ€
์ตœ๊ทผ์— ๋‹ฌ๋ฆฐ ๋Œ“๊ธ€
Total
Today
Yesterday
๋งํฌ
TAG more
ยซ   2025/11   ยป
์ผ ์›” ํ™” ์ˆ˜ ๋ชฉ ๊ธˆ ํ† 
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30
๊ธ€ ๋ณด๊ด€ํ•จ
๋ฐ˜์‘ํ˜•