PHP explode() in mysql ?

[Anon]

Hi peeps,
anyone know of a function in MYSQL that does the same as explode() in php ?

e.g. I have a value abc:fssd:sdsd and I want to explode it into 3 different fields..

Possible or Pipe Dream ?

Cheers

~ Carl Heaton ~

[Anon]

If abc:fssd:sdsd is in your database, why you don't use PHP itself.
Example:

Suppose that a field holding such type of data is FieldName,

$query = "select * from TableName...";
$result = mysql_query($query);
while($data = mysql_fetch_object($result)){
$assign = $data->FieldName;
$add = explode(":", $assign);
echo $add[0];
echo $add[1];
echo $add[2];

}