regex101: PCRE (Legacy) Match Workspace

(?i)applies the following effective flags to the remainder of the pattern: gmi

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

Negative Lookbehind(?<!\S)

\Sany non-whitespace character

likethe literal text like (case insensitive)

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

'%"the literal text '%"

.*?any character (except for line terminators), repeated any number of times

"%'the literal text "%'

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

Search reference

Regular Expression

(?i)(?<!\S)like\s*'%".*?"%'

Test String
New

Select Count(distinct c.requestId)  FROM Abc1Value c  WHERE 1=1 and c.templateName is NULL AND (c.quickStatus IS NULL OR c.quickStatus = 'S') AND (c.sCode='MYCODE'  OR exists (SELECT b.dseaReqId FROM drstSShareValue b WHERE b.dseaReqId=c.requestId and b.sCode='MYCODE'))  AND  (upper(c.licenseNo) like '%"12548"%' or upper(c.docLicenseNo) like '%""%' or upper(c.uncontrolledLicense) like '%""%' or upper(c.nonAuthNo) like '%""%' or upper(c.reAuthNo) like '%""%')  and  upper(c.grantedByCtryCode) like '%US%'

Regular Expression

Test StringNew

Test String
New