Mysql tips 功能...

1. mysql  GROUP_CONCAT() 使用 排序...

SELECT
  shop.id,
  shop.name,
  shop.user_id,
  shop.address,
  shop.map_location,
  shop.lyl,
  shop.introduce,
  -- 0 未认领，1 已经认领
  shop.is_renling,
  GROUP_CONCAT(img_url ORDER BY sb.sort DESC)  -- 在这里写 排序...而不是 末尾

FROM tc_shop shop LEFT JOIN tc_shop_banner sb ON shop.id = sb.shop_id


WHERE shop.id = 31 AND shop.is_shenhe = 1 AND shop.inblack = 0

 

 

 

 

　　

 

转载于:https://www.cnblogs.com/whm-blog/p/8888120.html