title: MYSQL insert comma separated values into separate fields?
body: <p>I know its a strange question, but I have one input field that does a live search for locations. The final value is displayed like this:</p>
  
  <p><code>State,Suburb,Post Code</code></p>
  
  <p><code>NSW,Sydney,2210</code></p>
  
  <p>What I need to do now is split the three values into single values and update them into my separate fields for one row.</p>
  
  <p>I don't want to update multiple rows but just one.</p>
  
  <p>e.g.: </p>
  
  <p><code>fields ( state | suburb | postcode )</code>
  <code>values ( NSW   | sydney | 2210     )</code></p>
  
  <p>What php commands would I use to split those commas off and create single $values for each item?</p>