Why does the regular expression take the last occurrence of a substring and not the first?

Question

PHP

Please help me. It is necessary to write a regular expression so that it selects what begins with INSERT INTO, then anything (including line breaks) and ends with the first occurrence of ');' .
Here's what I made.
$result = preg_match_all("/INSERT INTO(.|\n|\r)*\)\;/i", $content, $inserts);
but it doesn't work like that. Selects from INSERT INTO until the last ');' , and it is necessary to the first.
Thank you.

Answer 1

You are just lazy.
And they must be greedy.
https://learn.javascript.ru/regexp-greedy-and-lazy
U (ungreedy) flag to help
https://regex101.com/r/nK7aV6/1