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

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, '_Þ','_þ');