regex101: PCRE (Legacy) Match Workspace

Pro

=the literal = (61₁₀ / 75₈ / 3D₁₆)

\h*any horizontal whitespace character, repeated any number of times

Branch Reset Group(?|"([^"@]*@[^"@]+)"|'([^@']*@[^'@]*)')

1st Alternative"([^"@]*@[^"@]+)"

"the literal " (34₁₀ / 42₈ / 22₁₆)

Group 1([^"@]*@[^"@]+)

Negated Character Class[^"@]*

*matches any number of characters outside the set below:

"the literal " (34₁₀ / 42₈ / 22₁₆)

@the literal @ (64₁₀ / 100₈ / 40₁₆)

Negated Character Class[^"@]+

+matches at least one character outside the set below:

"the literal " (34₁₀ / 42₈ / 22₁₆)

@the literal @ (64₁₀ / 100₈ / 40₁₆)

"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative'([^@']*@[^'@]*)'

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Group 1([^@']*@[^'@]*)

Negated Character Class[^@']*

*matches any number of characters outside the set below:

@the literal @ (64₁₀ / 100₈ / 40₁₆)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

@the literal @ (64₁₀ / 100₈ / 40₁₆)

Negated Character Class[^'@]*

*matches any number of characters outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

@the literal @ (64₁₀ / 100₈ / 40₁₆)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

=\h*(?|"([^"@]*@[^"@]+)"|'([^@']*@[^'@]*)')

New

...sql statements

-- only this quoted string would match
select @sql = "select * from 
    Users where id = @id "
select @sql ='select * from 
    Users where id = @id '

-- other statements that wouldn't match because not in a pair of quotes
if ltrim(isnull(@stat,'')) <> '' and @stat <> '""'
begin
    select @sql = @sql + " and Stat in ("+@stat+")"
end
if isnull(@atype,'') <> '' 
begin
    select @sql = @sql + " and Type in ("+@atype+")"
end

...more sql statements