■
SELECT
username,
if(username = "test",
case when userId = 2 then "2"
else "other" END
,
case when userId = 1 then "1"
else "other2" END
)
FROM newuser n;
SELECT
username,
if(username = "test",
case when userId = 2 then "2"
else "other" END
,
case when userId = 1 then "1"
else "other2" END
)
FROM newuser n;