MySQL select into outfile formatting for CSV

I’m trying to do a select into outfile to a CSV. My table values can contain characters like r, n, comma, “(double quotes)