select nid, vid from node_revisions where format in (select format from filters where module='filter' and delta = 1);

select cid, nid from comments where format in (select format from filters where module='filter' and delta = 1);

select bid, info from boxes where format in (select format from filters where module='filter' and delta = 1);

used to find content that uses the PHP input filter....useful for upgrading core!

Drupal 5.x Find PHP code in database

mysql, php, drupal

MySQL