IN演算子の使いどころ ※OR条件でカラムが同じ場合
両者の結果は同じになります
SELECT
*
FROM
tbl_date
WHERE
date IN('2008-9-1','2008-10-1','2008-11-1');
SELECT
*
FROM
tbl_date
WHERE
date = '2008-9-1' OR
date = '2008-10-1' OR
date = '2008-11-1';
両者の結果は同じになります
SELECT
*
FROM
tbl_date
WHERE
date IN('2008-9-1','2008-10-1','2008-11-1');
SELECT
*
FROM
tbl_date
WHERE
date = '2008-9-1' OR
date = '2008-10-1' OR
date = '2008-11-1';