select * into outfile ‘/var/lib/mysql-files/xxx.csv’ CHARACTER SET gbk fields terminated by ‘,’ optionally enclosed by ‘"’ ESCAPED BY ‘’ lines terminated by ‘\r\n’ FROM xxx.xxx limit 200000 ;

用上面的SQL导出表到csv文件，但是打开csv出现了一个问题：有一个字段中有逗号，csv把逗号当做一个字段的开始，也被割开了。

请问这种情况如何解决？