Thread:Project:Support desk/how to run a query to search through all text on my site to find a 'string'

Mediawiki has a table in the database 'text' which contains the page content. It is saved as a [BLOB] file. I would like to run a query to search through all the text on the site to see which pages contain a certain 'string'. eg I want to find all the pages which contain the word 'elephant'. How do I run a query to search through the [blob] files?