<?php $re = '`substr\([^()]*\)\h*(?:=\h*\'[^\']*\'|IN\h*\([^()]*\))`mi'; $str = <<<STR SELECT * FROM tbl WHERE col_a = 'abc' AND SUBSTR(col_b, 7, 2) = 'cd' AND col_c LIKE 'ACD0%' AND SUBSTR(col_d, 10, 1) IN ('A','B','C') AND SUBSTR(col_e, 5, 3) = 'cde' AND SUBSTR(col_f, 2, 1) IN ('C','D','E') STR; preg_match_all($re, $str, $matches, 0); print_r($matches[0]);
You have javascript disabled. You will not be able to edit any code.