select DATE_FORMAT(date_sub(curdate(),interval 1 day),'%Y%m%d');
select * from mjsxd_opt_user_details where etldate = DATE_FORMAT(date_sub(curdate(),interval 1 day),'%Y%m%d')
select DATE_FORMAT(date_sub(curdate(),interval 1 day),'%Y%m%d');
select * from mjsxd_opt_user_details where etldate = DATE_FORMAT(date_sub(curdate(),interval 1 day),'%Y%m%d')