한발짝 성장하는 블로그 한발짝 성장하는 블로그

* CASE구문 SELECT 컴럼, 컬럼 ( CASE 비교 컬럼 WHEN 비교값 THEN '처리문' WHEN 비교값2 THEN '처리문2' ELSE '처리문' END ) AS 컬럼대체구문 FROM TABLE WHERE 조건 * 대소문자 구분하지 않고 검색하는 경우 SELECT * FROM TABLE WHERE CAST(조건 AS CHAR) LIKE "문자" * DATE_FORMAT(DATETIME, "%Y-%m-%d") SELECT ANIMAL_ID, NAME, CASE WHEN (SEX_UPON_INTAKE LIKE "Intact%") THEN "X" ELSE "O" END AS "중성화" FROM ANIMAL_INS ORDER BY ANIMAL_ID

출처 : java-school.net/jdbc/SQL-SELECT-Statement MySQL 예제 CREATE TABLE DEPT ( DEPTNO DECIMAL(2), DNAME VARCHAR(14), LOC VARCHAR(13), CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO) ); CREATE TABLE EMP ( EMPNO DECIMAL(4), ENAME VARCHAR(10), JOB VARCHAR(9), MGR DECIMAL(4), HIREDATE DATE, SAL DECIMAL(7,2), COMM DECIMAL(7,2), DEPTNO DECIMAL(2), CONSTRAINT PK_EMP PRIMARY KEY (EMPNO), CONSTRAINT FK_DEPTNO FOREI..