regex101: PCRE (Legacy) Match Workspace

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

SELECTthe literal text SELECT (case sensitive)

Group 1([^"]|\n|\"[^";]*\")*

*repeats the group contents below any number of times:

1st Alternative[^"]

Negated Character Class[^"]

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

2nd Alternative\n

\na line-feed (newline) character (ASCII 10)

3rd Alternative\"[^";]*\"

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

Negated Character Class[^";]*

*matches any number of characters outside the set below:

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

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

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

LIMITthe literal text LIMIT (case sensitive)

Group 2([^"]|\n|\"[^";]*\")*

*repeats the group contents below any number of times:

1st Alternative[^"]

Negated Character Class[^"]

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

2nd Alternative\n

\na line-feed (newline) character (ASCII 10)

3rd Alternative\"[^";]*\"

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

Negated Character Class[^";]*

*matches any number of characters outside the set below:

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

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

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

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Global pattern flags

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

Search reference

Regular Expression

\"SELECT([^"]|\n|\"[^";]*\")*LIMIT([^"]|\n|\"[^";]*\")*\";

New

// blah
$SelQuery = "SELECT DISTICNT C.firstname,C.lastname,C.id as clientid,QC.category_name,QR.cid,QR.catid,QR.rhid
                    FROM cms_question_report QR, cms_clients C,cms_questioncategory QC ,cms_reporthistory RH
                    WHERE C.id=QR.cid
                    AND QR.rhid=RH.id
                    AND QR.catid='".$objArray['catid']."'
                    AND QR.catid=QC.id
                    AND C.id IN($SelClids)
                    LIMIT $page_no,$this->Limit";

$SelQuery = "SELECT DISTICNT C.firstname,C.lastname,C.id as clientid,QC.category_name,QR.cid,QR.catid,QR.rhid
                    FROM cms_question_report QR, cms_clients C,cms_questioncategory QC ,cms_reporthistory RH
                    WHERE C.id=QR.cid
                    AND QR.rhid=RH.id
                    AND QR.catid='".$objArray['catid']."'
                    AND QR.catid=QC.id
                    AND C.id IN($SelClids)";

"SELECT LIMIT";
LIMIT

Regular Expressions 101

Regular Expression

Substitution