title: Any Way to Process Columns using MySQL from csv?
body: <p>I have a csv file that has an ipv4 network and mask in a form like: 41.74.160.0/20</p>
  <p>I want to separate this into the network long and the broadcast long so that I can check other longs that are within this range for matching purposes from another table. So far, I have stored it as just a string, since INET_ATON takes in a string, but I recently found out that it doesn't support the mask. I have also been using LOAD DATA INFILE as my solution for easily getting all the data in the table.</p>
  <p>However, in this new solution, the columns in my table will obviously not match the ones in my data. Is there any way to load data with processing on columns from csv files in MySql? If not, is there an easy way to do it in PHP?</p>