sql--> SELECT * FROM `transit_log` WHERE (`folder`= 'D100101' or `folder` like 'D100102%' or `folder` = 'iD500102' or `folder` = 'iD500101' or `folder` = 'ICER100101' ) AND `create_time` BETWEEN '' AND DATE_ADD('', INTERVAL 1 DAY) ORDER BY `create_time` DESC