<?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);
- Output for 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.25, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
- string(6) "prefix"
string(12) "column alias"
string(5) "alias"
preferences:
188.35 ms | 403 KiB | 201 Q