How to escape commas inside CSV values when importing table to MySQL?
From the MySQL Reference Manual, use the following options instead:
LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
Update to match your usage, but the important part is to drop the OPTIONALLY
from OPTIONALLY ENCLOSED BY
.