mysql
IN 연산자
👁 조회 10,882
📅 2013-01-08
IN 연산자는 조건의 범위를 지정하는데 사용
값은 콤마로 구분하며, 값 중에서 하나 이상과 일치하면 조건에 맞는 것으로 함.
[사용 예]
SELECT COUNT(*) AS NUM, level FROM member WHERE level IN('무료회원','일반회원','고급회원') GROUP BY level;
DELETE FROM member WHERE id IN (SELECT id FROM member_add WHERE level = '무료회원');
💬 댓글 2개
2013-01-21
SELECT * FROM member WHERE address IN('경기 과천시 주암동');
SELECT * FROM member WHERE address LIKE '%서소문%';
SELECT * FROM member WHERE INSTR(address_2, '서소문');
SELECT * FROM member WHERE address LIKE '%서소문%';
SELECT * FROM member WHERE INSTR(address_2, '서소문');
2021-07-29
where not
select * from TABLE_NAME where use = 'Y' and NOT dl_idx IN ('abc','defg','kgir') order by dl_code desc
select * from TABLE_NAME where use = 'Y' and NOT dl_idx IN ('abc','defg','kgir') order by dl_code desc
다음글
필드 변경, 추가, 삭제
이전글
IF Function