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

If your wiki doesn't use compressed storage options, you can simply issue an SQL SELECT statement using the LIKE matching operator, it should work fine: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like

mysql> select page_namespace,page_title from page,revision,text where old_text like '%francisco%' and old_id=rev_text_id and rev_page=page_id and page_latest=rev_id; ++---+ | page_namespace | page_title    | ++---+ |              0 | San_Francisco | ++---+

Note that if your wiki *does* use compressed storage options, this won't work at all.