模糊并且分页查询------记录

select * from `user` where name like "%王%" limit 0, 5

注意：limit分页第从0开始：

第一个参数是当前位置：第二个参数是每页显示条数

找出最开的是五个的话：0,5；

如果是1,5  就是从第二个到第6个

 

 

 

合并数据并分页：

``` 

SELECT    * FROM(
SELECT    * from (
select a.* ,'交易' as refund_or_pay from
        (select
        app_id,order_id,out_trade_no,price,order_state,trade_success_time,pay_type,tel,open_id from pay_orders where app_id = "3156f727625c4cbbb0b1b81ecaa5cf13" and create_time  >= "2019-09-19 11:29:09" and create_time <= "2021-01-31 23:55:49") a
        inner join ( select * from wechat_bill_detail
        where
        time_end  >= "2019-09-19 11:29:09" and time_end <= "2021-01-31 23:55:49"
        ) b    on a.out_trade_no = b.out_trade_no  
        UNION
        select a.app_id,a.order_id,p.id as
        'out_trade_no',p.refund_price as
        price,a.order_state,a.trade_success_time,a.pay_type,a.tel,a.open_id,'退款'
        as refund_or_pay
        from pay_refund p , wechat_bill_detail w , pay_orders
        a where p.id = w.out_trade_no and a.order_id =
        p.order_id
        and a.app_id =  "3156f727625c4cbbb0b1b81ecaa5cf13" and w.time_end  >= "2019-09-19 11:29:09" and w.time_end <= '2021-01-31 23:55:49' 
        ) as tba ORDER BY tba.trade_success_time ASC
        ) wecaht  limit 0,2

 

 

```