How to find a sring pattern in the body of nodes and blocks

Look into the body of nodes

SELECT nid,title FROM node_revisions where body like '%my_string%'

Look into the body of custom blocks

SELECT bid,info FROM boxes  where body like '%my_string%'