title: Function resembling the work of Explode in MySQL
body: <p>Is there any function in MySQL to explode data of a column and then retrieve it?
  Like if a column data is P:12 , then can the data be exploded on ':' and then read?</p>