MySQL export result set to CSV

Example:

SELECT 'item_id', 'item_name', 'item_comment', 'item_st', 'req_rank', 'acquire_type', 'item_type', 'item_category_type', 'price', 'image_id', 'reg_date', 'attack_p', 'defence_p', 'luck_p', 'enhance_type_attack', 'enhance_type_defence', 'enhance_type_luck', 'enhance_price_param1','enhance_price_param2', 'enhance_price_max', 'enhancement_limit', 'enhanceable', 'growth_type', 'clan_id', 'rarity', 'affix_1', 'affix_2', 'affix_3', 'actype'
UNION
SELECT `item_id`, `item_name`, `item_comment`, `item_st`, `req_rank`, `acquire_type`, `item_type`, `item_category_type`, `price`, `image_id`, `reg_date`, `attack_p`, `defence_p`, `luck_p`, `enhance_type_attack`, `enhance_type_defence`, `enhance_type_luck`, `enhance_price_param1`,`enhance_price_param2`, `enhance_price_max`, `enhancement_limit`, `enhanceable`, `growth_type`, `clan_id`, `rarity`, `affix_1`, `affix_2`, `affix_3`, `acquire_type` as actype FROM ninja_gear_master WHERE `item_id` IN ( 1213005, 2213001, 3013042 ) INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"';