3v4l.org

run code in 300+ PHP versions simultaneously

sponsor
bughunt
search
recent
about

@ 2017-05-26T16:24:17Z

<?php

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

$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);

var_dump($arr);

Output
Performance
VLD
References
Branches

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

preferences:dark modelive preview

57.56 ms | 402 KiB | 5 Q