regex101: paramaterised sql like expressions for sybase

Group 1((?<=[ )()']where)|(?<=[ )()']and)|(?<=[ )()']o[rn])|(?<=[ )()']if)|(?<=[ )()']when)|(?<=having))+

+repeats the group contents below at least once:

1st Alternative(?<=[ )()']where)

Positive Lookbehind(?<=[ )()']where)

Character Class[ )()']

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

)the literal ) (41₁₀ / 51₈ / 29₁₆)

(the literal ( (40₁₀ / 50₈ / 28₁₆)

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

wherethe literal text where (case insensitive)

2nd Alternative(?<=[ )()']and)

Positive Lookbehind(?<=[ )()']and)

Character Class[ )()']

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

)the literal ) (41₁₀ / 51₈ / 29₁₆)

(the literal ( (40₁₀ / 50₈ / 28₁₆)

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

andthe literal text and (case insensitive)

3rd Alternative(?<=[ )()']o[rn])

Positive Lookbehind(?<=[ )()']o[rn])

Character Class[ )()']

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

)the literal ) (41₁₀ / 51₈ / 29₁₆)

(the literal ( (40₁₀ / 50₈ / 28₁₆)

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

othe literal o (111₁₀ / 157₈ / 6F₁₆) (case insensitive)

Character Class[rn]

rthe literal r (114₁₀ / 162₈ / 72₁₆) (case insensitive)

nthe literal n (110₁₀ / 156₈ / 6E₁₆) (case insensitive)

4th Alternative(?<=[ )()']if)

Positive Lookbehind(?<=[ )()']if)

Character Class[ )()']

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

)the literal ) (41₁₀ / 51₈ / 29₁₆)

(the literal ( (40₁₀ / 50₈ / 28₁₆)

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

ifthe literal text if (case insensitive)

5th Alternative(?<=[ )()']when)

Positive Lookbehind(?<=[ )()']when)

Character Class[ )()']

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

)the literal ) (41₁₀ / 51₈ / 29₁₆)

(the literal ( (40₁₀ / 50₈ / 28₁₆)

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

whenthe literal text when (case insensitive)

6th Alternative(?<=having)

Positive Lookbehind(?<=having)

havingthe literal text having (case insensitive)

Group 2(\s|\()+

+repeats the group contents below at least once:

1st Alternative\s

\sany whitespace character

2nd Alternative\(

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Character Class[)(,'+_¥£$#\@\w\[\]\.\s]+

+matches at least one character from the set below:

)the literal ) (41₁₀ / 51₈ / 29₁₆)

(the literal ( (40₁₀ / 50₈ / 28₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

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

+the literal + (43₁₀ / 53₈ / 2B₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

¥the literal ¥ (165₁₀ / 245₈ / A5₁₆)

£the literal £ (163₁₀ / 243₈ / A3₁₆)

$the literal $ (36₁₀ / 44₈ / 24₁₆)

#the literal # (35₁₀ / 43₈ / 23₁₆)

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

\wany word character

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\sany whitespace character

likethe literal text like (case insensitive)

\s*any whitespace character, repeated any number of times

\(?optionally matches the literal ( (40₁₀ / 50₈ / 28₁₆)

\s*any whitespace character, repeated any number of times

Group 3(('((\w|%|'{2})*)')\s*\+)*

*repeats the group contents below any number of times:

Group 4('((\w|%|'{2})*)')

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

Group 5((\w|%|'{2})*)

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

\s*any whitespace character, repeated any number of times

\+the literal + (43₁₀ / 53₈ / 2B₁₆)

\s*any whitespace character, repeated any number of times

@pthe literal text @p (case insensitive)

\d+a digit, repeated at least once

\s*any whitespace character, repeated any number of times

Group 7(\+('%'))*

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

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

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

Search reference

Regular Expression

((?<=[ )()']where)|(?<=[ )()']and)|(?<=[ )()']o[rn])|(?<=[ )()']if)|(?<=[ )()']when)|(?<=having))+(\s|\()+[)(,'+_¥£$#\@\w\[\]\.\s]+like\s*\(?\s*(('((\w|%|'{2})*)')\s*\+)*\s*@p\d+\s*(\+('%'))*\)

New

select * from a where #myTable$@_¥£.$@_¥£#columnName like ('%'+@p2+'%')
select * from a where #myTable$_¥£.$_¥£#columnName like ('%'+@p2+'%')

(\w|\[|\]|\.|\s|'|\+|\(|\)|\,)

select a from b where h like ('%'+@p2+'%')
having b.d like   ('%'+@p2)
)join c on a.b      like (@p2+'%')
 and      a.b like (@p2)
 if a like ('%abc24''as'+@p2+'%')
 case when a like                ('%'+@p2+'%')     
 
 where (((a like ('%'+   @p2+'%'))))
 where a + 'b' like  ('%'+@p2+'%')
 where concat(a,b) like  ('%'+@p2+'%') or ltrim(a) like  ('%'+@p2+'%')
select * from a where concat(a,b) like 'a' and c like d or ltrim(a) like  ('%'+@p2+'%')
 where isnull(ltrim(a), '0')    like   ('%'+@p2+'%')
 where a + 'b' LIKe  ('%'+@p2+'%')


vICM_EVENTlike roadshowev0like_ where upper(roadshowev0like_.EVENT_NAME) like ('%'+@p1+'%') or upper(roadshowev0like_.EVENT_SYMBOLlike) like ('%'+@p2+'%') and e_.EVENT_SYMBOLike like('%'+@p2+'%')

from vICM_INVESTOR investor0_ where (upper(investor0_.OrgId) like ('%'+@p1+'%') or upper(investor0_.Name) like ('%'+@p2+'%')) and investor0_.IsDeactivated=@p3 order by investor0_.Name asc

 where ((h.g) + upper(concat(investor0_.OrgId, 'd') + (a.d)) like ('%'+@p1+'%') 

 or upper(investor0_.Name) like ('%'+@p2+'%')) and investor0_.IsDeactivated=@p3 order by investor0_.Name asc

 where (a.b like ('%'+@p2+'%')) and d.g like ('%'+@p2+'%')


(where a.b like ('%'+@p2)

 if a like ('%'+@p2)
join a on b.d like ('%'+@p2)

 // not supported
 where a like 'b' and c like ('%'+@p2+'%')
 where a like (' '+@p1+'%') 
// supported
 where a like ('%'+@p1+'%') and c like ('%'+@p2+'%')

Regular Expressions 101

Regular Expression

Extraction