certain csv fields to mysql

[eluser]johnpeace[/eluser]
I would go about it using Sequel Pro's (my OS X MySQL client) excellent CSV import feature.

If it has to be done repeatedly as part of the app, you'll probably need to write a script that will loop through each row and parse each cell into the correct field in your table. I'm sure countless examples of how to do that can be found online.