Difference between revisions of "MediaWiki/Sql"
Jump to navigation
Jump to search
(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%'
)
