CONCAT

[unemployment]

how do I concat this field name while leaving a space?

 

CONCAT(`users`.`firstname`, `users`.`lastname`)

[Pikachu2000]

CONCAT_WS() is what you'll need.

[unemployment]

CONCAT_WS() is what you'll need.

 

CONCAT_WS(`users`.`firstname`, `users`.`lastname`)

 

I must be misunderstanding  this.  With the code above, it deletes my firstname from being displayed. 

[Pikachu2000]

Actually, I just noticed that there are only two values in there. You can still use CONCAT_WS(), or you can just throw a space between the two values in CONCAT(). I tend to prefer the _WS version for retrieving more than 2 values unless the separator will be changing.

 

CONCAT(`users`.`firstname`, ' ', `users`.`lastname`)

[unemployment]

Actually, I just noticed that there are only two values in there. You can still use CONCAT_WS(), or you can just throw a space between the two values in CONCAT(). I tend to prefer the _WS version for retrieving more than 2 values unless the separator will be changing.

 

CONCAT(`users`.`firstname`, ' ', `users`.`lastname`)

 

Thanks, that worked. Did you get my PMs today?