문서의 이전 판입니다!

빈 값 체크

물리명	논리명	타입
유형	type	문자
값	value	문자

CREATE TABLE ex_null_empty (
	type VARCHAR(100),
	value VARCHAR(100)
);

INSERT INTO ex_null_empty (type, value) VALUES ('NULL', NULL);
INSERT INTO ex_null_empty (type, value) VALUES ('빈 문자열', '');

MySQL/MariaDB

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NULL OR value = ''
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NOT NULL AND value <> ''
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NULL OR value = ''
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NOT NULL AND value <> ''
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NULL
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NOT NULL
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NULL OR value = ''
;

SELECT
	*
FROM
	ex_null_empty
WHERE
	value IS NOT NULL AND value <> ''
;