select (SELECT name FROM mysql.help_category WHERE help_category_id = 1) as name,
case 1 when 1 then "Some" else "Other" end AS foo bar FROM a;