- substr: documentation ( source)
- var_dump: documentation ( source)
- strpos: documentation ( source)
- strrpos: documentation ( source)
<?php
$str = 'prefix.column alias';
$pos = strpos ($str, '.');
$prefix = substr ($str, 0, $pos);
$name = substr($str, $pos + 1);
$posr = strrpos ($name, ' ');
$alias = substr ($name, $posr + 1);
var_dump ($prefix, $name, $alias);
//echo substr ($str, $pos + 1, $posr - $pos - 1);