Read CSV / external file from MySQL

is there a way to read .csv file using query in mySQL?

i've been search and it end up with LOAD DATA (simillar to SELECT..INTO)

i want to read the csv so that i can update records based on that file

thanks,
erick