A Regex in php that grabs all the quries that are defined.

grep_quries_from_files.php

chdir('/var/www/website');

$matchingTable = 'sometable';
$regex = 'SELECT(\n|\s|\w|.)*?(?='.$matchingTable.')(\n|\s|\w|.)*?(?=(\'|");)'; // could change to update or delete
$filepaths = glob('*.*');
foreach($filepaths as $filepath){
	if(!file_exists(realpath($filepath))){
		echo $filepath.PHP_EOL;
		continue;
	}
	// grab all quries from those files
	preg_match_all('/'.$regex.'/', file_get_contents(realpath($filepath)),$queries);
	$queries = $queries[0];
	foreach($queries as $query){
		echo str_pad($filepath,60).' - '.$query.PHP_EOL;
	}
}