title: php explode like function in mysql
body: <p>I have a column in my database name location which have city name and country name in this format <code>New york,America</code>. I want to run a select query with the explode function like which we use in php to separate values like this
  so that i can get comma , separated values</p>
  
  <pre><code>select explode(",",location) from address;
  </code></pre>
  
  <p>Also with the alias of city column holding New York and alias of country holding value of America. So that i can use them in my store procedure and insert this values in references table in the columns city and country</p>