MYSQL Query to check if Value is Null/Blank

Question

My Query looks like this

SELECT Distinct tm.teamid,tm.Team_Name,CONCAT_WS(' ',tu.FirstName+' '+tu.LastName) as Leader  FROM tblGameRelation tgr 
LEFT JOIN tblTeam tm ON tgr.teamid = tm.teamid AND tgr.gameid = 62
LEFT JOIN tblUsersRelation tur ON tgr.typeid=tur.typeid AND tur.usertypeid=1
LEFT JOIN tblUsers tu ON tu.UserId= tur.UserId

My Problem is that when "Leader" field is Blank it should display "-" a Dash.I tried using if null but its not working, not sure if Mysql can do this, i know its possible in MSSQL SERVER

Bojangles · Accepted Answer · 2011-11-05 15:36:29Z

5

COALESCE() is your friend here:

COALESCE(CONCAT_WS(' ', tu.FirstName, tu.LastName), '-') AS leader

COALESCE() will pick the first expression, value or field given to it that isn't NULL and returns it.

edited Nov 5, 2011 at 15:36

answered Nov 5, 2011 at 15:22

Bojangles

102k50 gold badges175 silver badges209 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shef Over a year ago

+1. Change the concatenation from CONCAT_WS(' ',tu.FirstName+' '+tu.LastName) to CONCAT_WS(' ', tu.FirstName, tu.LastName).

Collectives™ on Stack Overflow

MYSQL Query to check if Value is Null/Blank

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related