17. Mysql 기초, Case When 구문으로 필드값에 따라 출력값 변경 가능
Synopsis
case when 구문을 사용하여 필드값에 따라 출력 내용을 자유롭게 조정할 수가 있습니다.
You Might Also Like
![[즐겁게 배우는 SQL #24] 서브 질의를 배우자 - CASE](https://i.ytimg.com/vi/6kKj-y4fniI/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCSgoyT-jTN2P1cgQ3jzBze6P4RMQ)
![[Express + mysql 기초] 10_상세조회 하기(select * from)](https://i.ytimg.com/vi/O8U89lLagU0/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLD-Sc8PTEY7ltvdnb9HSiAtBdymTQ)
![[SQL 기초 강의] 11강. SQL 프로그래밍(IF문, CASE문, WHILE문, 동적SQL)](https://i.ytimg.com/vi/IOCsreDYqFE/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBDr2dtdrx_cbGok1H2-xpz2LrdiQ)
![[SQL 기초 강의] 9강. MySQL의 데이터 형식(정수형, 문자형, 실수형, 날짜형)과 형 변환](https://i.ytimg.com/vi/1YmWy-7-OhQ/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAF3gh0_u5hCNi3SOCGMag-ivL0UA)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.