how to select data in mysql

[shaddf]

I have this query :

select GROUP_CONCAT(Other_type)as projtype2,PrT_id  from  _Otherproject_typetbl,_project_typetbl
where _Otherproject_typetbl.Other_id=_project_typetbl.Other_id and Project_id=in_projid;

and it gives this result:

 

+-----------+--------+
| projtype2 | PrT_id |
+-----------+--------+
| All_other | HR_3   |
+-----------+--------+
1 row in set (0.04 sec)
 

I would to set the value incase it is "Allother" to be set to empty  or null  in any of the columns

+-----------+--------+
| projtype2 | PrT_id |
+-----------+--------+
| null         | HR_3   |
+-----------+--------+
1 row in set (0.04 sec)

[ginerjm]

Is this an sql question? Perhaps you want to try a different forum? Sounds like a situation for a CASE statement.

[shaddf]

Is this an sql question? Perhaps you want to try a different forum? Sounds like a situation for a CASE statement.

It is a mysql question .how can Iselect data while replacing all returned columns with "All_other as null"

[Barand]

SELECT GROUP_CONCAT(NULLIF(Other_type, 'All_other') as projtype2, ...

[shaddf]

SELECT GROUP_CONCAT(NULLIF(Other_type, 'All_other') as projtype2, ...

thanks