[Wikipedia-l] It's about its

Poor, Edmund W Edmund.W.Poor at abc.com
Tue Oct 22 17:06:26 UTC 2002


> There are 1,178 pages in article space containing the word "it's". If 
> you _really_ want to wade through them looking for the erroneous ones, 
> go to the SQL query page and run:
> 
>   SELECT cur_title from cur where cur_namespace=0 and
>   cur_text regexp "[[:<:]]it's[[:>:]]" order by cur_title
> 
> It takes a while -- hence my idea to cut the list down in most cases!

Is there a way to tell SQL just to return the first 20 records? I don't want to slow down the server -- nor would I really want to wade through more than 20 pages at a time -- my brain might spring a leak :-)

Ed Poor



More information about the Wikipedia-l mailing list