Projet:Restauration lien rouge/Script/Capitalisation

Un article de Wikipédia, l'encyclopédie libre.

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