SELECT *
FROM `$DB_TABLE`
WHERE DATE >= DATE_ADD( '20170314', INTERVAL 0
DAY )
AND DATE < DATE_ADD( '20170412', INTERVAL 1
DAY )
ORDER BY no
LIMIT 0 , 30
* SELECT * FROM 테이블명 WHERE 컬러명 > 기간 AND 컬럼명 < 기간
SELECT * FROM $db_table WHERE date > 20210101 and date < 20211231
