mysql模糊查询

select count(*) from xxxxxx  where xxx_time>1568649600 and xxxx like '%ALIPAY%';

select xxxxx2,count(*) from xxxxxxxxxx where xxxx_time>1568649600 group by xxxxx2;