Wikipedia:Dead-end pages/How to update

Download and install the MySQL database engine from the [http://dev.mysql.com/ MySQL web site]. Download the latest en database dump from the [http://download.wikimedia.org/ Wikipedia database download] site. Unzip the database dump and load the resulting file into MySQL with the source command.

Now issue the SQL statement:

select cur_title
from cur
where locate( '[[', cur_text ) = 0
and cur_namespace = 0
order by cur_title;

This will return a list of all articles that do not contain at least one '""' - this means they're almost certainly not wikified. Open the list in a text editor (you may find it helpful to save it using MySQL's tee command), tidy it up and cut and paste it into [[Wikipedia:Deadend pages.