Regular Expressions 101

Community Patterns

sql: insert into

3

Regular Expression
PCRE (PHP <7.3)

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

Description

insert into (a,b,c) values (1,2.3,"test");

Submitted by suat erenler - sua.gen.tr - 9 years ago