sql语句怎么执行

346257592

语句  $sql="select id,thumb,state,title,trade,retail,price from shop_list where 1=1  order by CASE `state` when '3' then '-4' when '0' then '-3' when '2' then '-2' when '1' then '-1' else `state` end asc";
请问这条语句怎么执行？  并且还要有分页   25个一页  

请帮忙看看  谢谢各位了