$re = '/(INSERT INTO(?s:.)*?VALUES(?s:.)*?\))/m';
$str = ' ...
SOME COMMAND TEXT
SOME COMMAND TEXT
INSERT INTO table (CAMPO 1, CAMPO 2)
VALUES (1, 2)
SOME COMMAND TEXT
INSERT INTO table (CAMPO 1, CAMPO 2) VALUES (1, 2)
SOME COMMAND TEXT
INSERT INTO table (CAMPO 1, CAMPO 2) VALUES (1, 2)
SOME COMMAND TEXT
INSERT INTO table VALUES (1, 1, 1, 1, 1);
INSERT INTO table VALUES (1, 1, 1, 1, 1) ;
INSERT INTO table VALUES (1, 1, 1, 1, 1);
INSERT INTO table VALUES (1, 1, 1, 1, 1) ;
SOME COMMAND TEXT
SOME COMMAND TEXT
...';
preg_match_all($re, $str, $matches, PREG_SET_ORDER, 0);
// Print the entire match result
var_dump($matches);
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for PHP, please visit: http://php.net/manual/en/ref.pcre.php