New page: Here is a query that will show you the pages in your wiki that contain a particular string. In this example, I wanted to find all pages that were using the 'Icon' extension parser extens... |
link to Manual and taged help |
||
| Line 1: | Line 1: | ||
Here is a query that will show you the pages in your wiki that contain a particular string. In this example, I wanted to find all pages that were using the 'Icon' extension parser extension magic word '#icon'. | Here is a query that will show you the pages in your wiki that contain a particular string. In this example, I wanted to find all pages that were using the 'Icon' extension parser extension magic word '#icon'. | ||
<source lang="sql"> | <source lang="sql"> | ||
| Line 7: | Line 6: | ||
WHERE rev_text_id | WHERE rev_text_id | ||
IN ( | IN ( | ||
SELECT old_id | |||
FROM `text` | |||
WHERE old_text LIKE '%#icon%' | |||
) | ) | ||
</source> | </source> | ||
== See Also == | |||
* [[mw:Manual:Database_access]] | |||
[[Category:Database]] | [[Category:Database]] | ||
[[Category:Wiki]] | [[Category:Wiki]] | ||
[[Category:Development]] | |||
[[Category:Help]] | |||
Revision as of 13:34, 31 October 2008
Here is a query that will show you the pages in your wiki that contain a particular string. In this example, I wanted to find all pages that were using the 'Icon' extension parser extension magic word '#icon'.
SELECT DISTINCT page_title
FROM page
RIGHT JOIN revision ON page_id = rev_page
WHERE rev_text_id
IN (
SELECT old_id
FROM `text`
WHERE old_text LIKE '%#icon%'
)
