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