3v4l.org

run code in 300+ PHP versions simultaneously

sponsor
bughunt
search
recent
about

@ 2017-05-26T16:02:42Z

<?php

$pattern = "/(SELECT|FROM|WHERE|LEFT JOIN|ORDER BY) (.+?)(?= SELECT|FROM|WHERE|LEFT JOIN|ORDER BY|$)/m";

$sql = "SELECT 
            id, 
            nome 
        FROM table as t 
        WHERE t.id = 123 
            LEFT JOIN t2 ON t2.id = t.id 
        ORDER BY t.name
        ";

preg_match_all($pattern, $sql, $arr, PREG_SET_ORDER);

var_dump($arr);

Output
Performance
VLD
References
Branches

var_dump: documentation ( source)
preg_match_all: documentation ( source)

preferences:dark modelive preview

61.79 ms | 402 KiB | 5 Q