Regular Expressions 101

Community Patterns

Split SQL statements on 'GO'

1

Regular Expression
PCRE (PHP <7.3)

/
(?:\s*|\r)+GO(\s*);*\s*(?:\r|\n)
/
gmi

Description

Splits a SQL script into sections seperated by GO statement

Submitted by Michael Skovslund - 8 years ago