Jump to content

Wikipedia:WikiProject Red Link Recovery/Link matching script/Capitalisation

Add links
From Wikipedia, the free encyclopedia

This only touches the first letter of words following a space right now. This produces ample results and avoids touching the first non-case-senstive letter of each title. 

update crushed_art set title = replace( title, '_A', '_a' );
update crushed_art set title = replace( title, '_B', '_b' );
update crushed_art set title = replace( title, '_C', '_c' );
update crushed_art set title = replace( title, '_D', '_d' );
update crushed_art set title = replace( title, '_E', '_e' );
update crushed_art set title = replace( title, '_F', '_f' );
update crushed_art set title = replace( title, '_G', '_g' );
update crushed_art set title = replace( title, '_H', '_h' );
update crushed_art set title = replace( title, '_I', '_i' );
update crushed_art set title = replace( title, '_J', '_j' );
update crushed_art set title = replace( title, '_K', '_k' );
update crushed_art set title = replace( title, '_L', '_l' );
update crushed_art set title = replace( title, '_M', '_m' );
update crushed_art set title = replace( title, '_N', '_n' );
update crushed_art set title = replace( title, '_O', '_o' );
update crushed_art set title = replace( title, '_P', '_p' );
update crushed_art set title = replace( title, '_Q', '_q' );
update crushed_art set title = replace( title, '_R', '_r' );
update crushed_art set title = replace( title, '_S', '_s' );
update crushed_art set title = replace( title, '_T', '_t' );
update crushed_art set title = replace( title, '_U', '_u' );
update crushed_art set title = replace( title, '_V', '_v' );
update crushed_art set title = replace( title, '_W', '_w' );
update crushed_art set title = replace( title, '_X', '_x' );
update crushed_art set title = replace( title, '_Y', '_y' );
update crushed_art set title = replace( title, '_Z', '_z' );

update crushed_links set link = replace( link, '_A', '_a' );
update crushed_links set link = replace( link, '_B', '_b' );
update crushed_links set link = replace( link, '_C', '_c' );
update crushed_links set link = replace( link, '_D', '_d' );
update crushed_links set link = replace( link, '_E', '_e' );
update crushed_links set link = replace( link, '_F', '_f' );
update crushed_links set link = replace( link, '_G', '_g' );
update crushed_links set link = replace( link, '_H', '_h' );
update crushed_links set link = replace( link, '_I', '_i' );
update crushed_links set link = replace( link, '_J', '_j' );
update crushed_links set link = replace( link, '_K', '_k' );
update crushed_links set link = replace( link, '_L', '_l' );
update crushed_links set link = replace( link, '_M', '_m' );
update crushed_links set link = replace( link, '_N', '_n' );
update crushed_links set link = replace( link, '_O', '_o' );
update crushed_links set link = replace( link, '_P', '_p' );
update crushed_links set link = replace( link, '_Q', '_q' );
update crushed_links set link = replace( link, '_R', '_r' );
update crushed_links set link = replace( link, '_S', '_s' );
update crushed_links set link = replace( link, '_T', '_t' );
update crushed_links set link = replace( link, '_U', '_u' );
update crushed_links set link = replace( link, '_V', '_v' );
update crushed_links set link = replace( link, '_W', '_w' );
update crushed_links set link = replace( link, '_X', '_x' );
update crushed_links set link = replace( link, '_Y', '_y' );
update crushed_links set link = replace( link, '_Z', '_z' );

update crushed_art set title = replace( title, '_À','_à');
update crushed_art set title = replace( title, '_Á','_á');
update crushed_art set title = replace( title, '_Â','_â');
update crushed_art set title = replace( title, '_Ã','_ã');
update crushed_art set title = replace( title, '_Ä','_ä');
update crushed_art set title = replace( title, '_Å','_å');
update crushed_art set title = replace( title, '_Æ','_æ');
update crushed_art set title = replace( title, '_Ç','_ç');
update crushed_art set title = replace( title, '_È','_è');
update crushed_art set title = replace( title, '_É','_é');
update crushed_art set title = replace( title, '_Ê','_ê');
update crushed_art set title = replace( title, '_Ë','_ë');
update crushed_art set title = replace( title, '_Ì','_ì');
update crushed_art set title = replace( title, '_Í','_í');
update crushed_art set title = replace( title, '_Î','_î');
update crushed_art set title = replace( title, '_Ï','_ï');
update crushed_art set title = replace( title, '_Ñ','_ñ');
update crushed_art set title = replace( title, '_Ò','_ò');
update crushed_art set title = replace( title, '_Ó','_ó');
update crushed_art set title = replace( title, '_Ô','_ô');
update crushed_art set title = replace( title, '_Õ','_õ');
update crushed_art set title = replace( title, '_Ö','_ö');
update crushed_art set title = replace( title, '_Ø','_ø');
update crushed_art set title = replace( title, '_Ù','_ù');
update crushed_art set title = replace( title, '_Ú','_ú');
update crushed_art set title = replace( title, '_Û','_û');
update crushed_art set title = replace( title, '_Ü','_ü');
update crushed_art set title = replace( title, '_Ý','_ý');
update crushed_art set title = replace( title, '_Þ','_þ');

update crushed_links set link = replace( link, '_À','_à');
update crushed_links set link = replace( link, '_Á','_á');
update crushed_links set link = replace( link, '_Â','_â');
update crushed_links set link = replace( link, '_Ã','_ã');
update crushed_links set link = replace( link, '_Ä','_ä');
update crushed_links set link = replace( link, '_Å','_å');
update crushed_links set link = replace( link, '_Æ','_æ');
update crushed_links set link = replace( link, '_Ç','_ç');
update crushed_links set link = replace( link, '_È','_è');
update crushed_links set link = replace( link, '_É','_é');
update crushed_links set link = replace( link, '_Ê','_ê');
update crushed_links set link = replace( link, '_Ë','_ë');
update crushed_links set link = replace( link, '_Ì','_ì');
update crushed_links set link = replace( link, '_Í','_í');
update crushed_links set link = replace( link, '_Î','_î');
update crushed_links set link = replace( link, '_Ï','_ï');
update crushed_links set link = replace( link, '_Ñ','_ñ');
update crushed_links set link = replace( link, '_Ò','_ò');
update crushed_links set link = replace( link, '_Ó','_ó');
update crushed_links set link = replace( link, '_Ô','_ô');
update crushed_links set link = replace( link, '_Õ','_õ');
update crushed_links set link = replace( link, '_Ö','_ö');
update crushed_links set link = replace( link, '_Ø','_ø');
update crushed_links set link = replace( link, '_Ù','_ù');
update crushed_links set link = replace( link, '_Ú','_ú');
update crushed_links set link = replace( link, '_Û','_û');
update crushed_links set link = replace( link, '_Ü','_ü');
update crushed_links set link = replace( link, '_Ý','_ý');
update crushed_links set link = replace( link, '_Þ','_þ');
Retrieved from "https://en.wikipedia.org/w/index.php?title=Wikipedia:WikiProject_Red_Link_Recovery/Link_matching_script/Capitalisation&oldid=217064113"