本周
SELECT c_client_order.* from c_client_order WHERE YEARWEEK(date_format(c_client_order.createdate,'%Y/%m/%d')) = YEARWEEK(now());
上周
SELECT c_client_order.* from c_client_order WHERE YEARWEEK(date_format(c_client_order.createdate,'%Y/%m/%d')) = YEARWEEK(now())-1;