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