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

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' );