regex101: Regex Replace params SQL

1st Alternative[a-zA-z\-]+( )+?=( )+?(:id)( +)?and

Character Class[a-zA-z\-]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

A-zone character from A (65₁₀) to z (122₁₀) (case insensitive)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

Group 1( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

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

Group 2( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

Group 3(:id)

:idthe literal text :id (case insensitive)

Group 4( +)?

?repeats the group contents below at most once:

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

andthe literal text and (case insensitive)

2nd Alternativeand( +)?[a-zA-z\-]+( )+?=( )+?(:id)$

andthe literal text and (case insensitive)

Group 5( +)?

?repeats the group contents below at most once:

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

Character Class[a-zA-z\-]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

A-zone character from A (65₁₀) to z (122₁₀) (case insensitive)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

Group 6( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

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

Group 7( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

Group 8(:id)

:idthe literal text :id (case insensitive)

$end of line

3rd Alternativewhere( )+?[a-zA-z\-]+( )+?=( )+?(:id)$

wherethe literal text where (case insensitive)

Group 9( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

Character Class[a-zA-z\-]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

A-zone character from A (65₁₀) to z (122₁₀) (case insensitive)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

Group 10( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

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

Group 11( )+?

+?repeats the group contents below at least once:

the literal (32₁₀ / 40₈ / 20₁₆)

Group 12(:id)

:idthe literal text :id (case insensitive)

$end of line

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Search reference

Regular Expression

[a-zA-z\-]+( )+?=( )+?(:id)( +)?and|and( +)?[a-zA-z\-]+( )+?=( )+?(:id)$|where( )+?[a-zA-z\-]+( )+?=( )+?(:id)$

New

 id = :id
 id = id

SELECT * FROM A ID IN (select ID from users where id_ec = :id)

select * from users where id = :id and name = :name

select * from users where name = :name and id = :id  aNd name = :name


select * from users where name = :name and name = :name and id = :id