select *
from newstable
where abs(datediff(sysdate(), pubtime))<=1 Order by pubtime Desc limit 100;
INSERT INTO table1 (id, name) VALUES (1, 'record1') ON DUPLICATE KEY UPDATE name = 'record1';
select *
from newstable
where abs(datediff(sysdate(), pubtime))<=1 Order by pubtime Desc limit 100;
INSERT INTO table1 (id, name) VALUES (1, 'record1') ON DUPLICATE KEY UPDATE name = 'record1';