Regular Expressions 101

Community Patterns

SQL: insert into

0

Regular Expression
PCRE (PHP <7.3)

/
insert[\s]+into[\s]+\([\s]*(?<columns>.*?)[\s]*\)[\s]+values[\s]+\((?<values>.*?)[\s]*\);
/
gmi

Description

insert[\s]+into[\s]+([\s](?<columns>.?)[\s])[\s]+values[\s]+((?<values>.?)[\s]*);

Submitted by suat erenler - 9 years ago