鍍金池/ 問答/數(shù)據(jù)庫/ mysql查詢sql幫忙

mysql查詢sql幫忙

SELECT u.`username`,wa.`title`,wa.`realmoney`,w.* 
                    FROM `wwj_winner` w 
                    LEFT JOIN `wwj_wawa` wa ON w.`wid` = wa.`id`
                    LEFT JOIN `wwj_user` u ON w.`uid` = u.`id`
                    WHERE 1=1 and out_status = 0 and name != ''
                       GROUP BY uid
                    ORDER BY w.`address_addtime` DESC 
                    LIMIT 0,20

現(xiàn)在我想where條件中 name為空的時候不使用group by uid。我該怎么改sql

回答
編輯回答
我不懂

WHERE 1=1 and out_status = 0 and name != '' and name is not null

2017年6月14日 10:03
編輯回答
糖果果
SELECT u.`username`,wa.`title`,wa.`realmoney`,w.* 
FROM `wwj_winner` w 
LEFT JOIN `wwj_wawa` wa ON w.`wid` = wa.`id`
LEFT JOIN `wwj_user` u ON w.`uid` = u.`id`
WHERE 1=1 and out_status = 0 and name != '' GROUP BY uid
union
SELECT u.`username`,wa.`title`,wa.`realmoney`,w.* 
FROM `wwj_winner` w 
LEFT JOIN `wwj_wawa` wa ON w.`wid` = wa.`id`
LEFT JOIN `wwj_user` u ON w.`uid` = u.`id`
WHERE 1=1 and out_status = 0 and name != ''
ORDER BY w.`address_addtime` DESC 
LIMIT 0,20
2017年10月26日 22:34