Voir la source de Requête pour repérer toutes les tables de critères ayant un double underscore dans le nom

 SELECT CRITERE FROM CRITERES WHERE CRITERE LIKE '%__%';
Exemple pour la table c_n__fac :
Pour chacune des tables concernées :
 INSERT INTO c_n__fac  SELECT * FROM c_n_fac c;
 INSERT INTO CRITERES (volume, critere, type, format, description, visu, visuSearch) select volume, 'c_n__fac' as critere, type, format, description, visu, visuSearch from CRITERES where critere = 'c_n_fac';

 update groupcritere set critere = 'c_n__fac' where critere = 'c_n_fac';
 update usercritere set critere = ' c_n__fac' where critere = 'c_n_fac';

 update recherches set critere1 = 'c_n__fac' where critere1 = 'c_n_fac';
 update recherches set critere2 = 'c_n__fac' where critere2 = 'c_n_fac';
 update recherches set critere3 = 'c_n__fac' where critere3 = 'c_n_fac';
 update recherches set critere4 = 'c_n__fac' where critere4 = 'c_n_fac';
 update recherches set critere5 = 'c_n__fac' where critere5 = 'c_n_fac';
 update recherches set critere6 = 'c_n__fac' where critere6 = 'c_n_fac';
 update recherches set critere7 = 'c_n__fac' where critere7 = 'c_n_fac';
 update recherches set critere8 = 'c_n__fac' where critere8 = 'c_n_fac'; 
 update recherches set critere9 = 'c_n__fac' where critere9 = 'c_n_fac';
 update recherches set critere10 = 'c_n__fac' where critere10 = 'c_n_fac';
 update search_advanced set critere = 'c_n__fac' where critere = 'c_n_fac';
 update search_advanced set critere_changed = 'c_n__fac' where critere_changed = 'c_n_fac';
 update searchtemp set critere = 'c_n__fac' where critere = 'c_n_fac';