Should I put the result in parentheses?

Question

MySQL

Hello.
Here is the procedure:

BEGIN
set @i:=0;
SELECT @i:[email protected]+1 as number, CONCAT_WS(' ',value1, value2)
FROM job, legal, contract 
WHERE contract_id = param1 AND type_job = legal_id AND id_contract = contract_id; 
END

It is required that value1(value2) be displayed, but value2 can be null and then the parentheses are not needed.
Thanks in advance.

Answer 1

IF(`value2` IS NULL, `value1`, CONCAT(`value1`, '(', `value2`, ')'))