New file |
0,0 → 1,88 |
|
|
/**************************************************** |
COLLECTION BOTANIQUE |
*****************************************************/ |
|
|
/* Champ ccb_truk_degradation_specimen */ |
|
SET @valeur = '%Très important [1]%'; |
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très important [1]','30748') |
WHERE ccb_truk_degradation_specimen LIKE '%Très important [1]%'; |
|
SET @valeur = '%Important [2]%'; |
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Important [2]','30749') |
WHERE ccb_truk_degradation_specimen LIKE '%Important [2]%'; |
|
SET @valeur = '%Moyen [3]%'; |
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Moyen [3]','30750') |
WHERE ccb_truk_degradation_specimen LIKE '%Moyen [3]%'; |
|
SET @valeur = '%Faible [4]%'; |
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Faible [4]','30751') |
WHERE ccb_truk_degradation_specimen LIKE '%Faible [4]%'; |
|
SET @valeur = '%Très faible [5]%'; |
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très faible [5]','30752') |
WHERE ccb_truk_degradation_specimen LIKE '%Très faible [5]%'; |
|
|
/* Champccb_truk_degradation_presentation */ |
|
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très important [1]','30748') |
WHERE ccb_truk_degradation_presentation LIKE '%Très important [1]%'; |
|
|
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Important [2]','30749') |
WHERE ccb_truk_degradation_presentation LIKE '%Important [2]%'; |
|
|
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Moyen [3]','30750') |
WHERE ccb_truk_degradation_presentation LIKE '%Moyen [3]%'; |
|
|
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Faible [4]','30751') |
WHERE ccb_truk_degradation_presentation LIKE '%Faible [4]%'; |
|
|
UPDATE coel_collection_botanique |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très faible [5]','30752') |
WHERE ccb_truk_degradation_presentation LIKE '%Très faible [5]%'; |
|
|
/**************************************************** |
PERSONNE |
*****************************************************/ |
|
UPDATE coel_personne |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FAX','30747') |
WHERE cp_truk_telephone LIKE '%FAX%'; |
|
UPDATE coel_personne |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'GSM','2014') |
WHERE cp_truk_telephone LIKE '%GSM%'; |
|
UPDATE coel_personne |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FIX','2015') |
WHERE cp_truk_telephone LIKE '%FIX%'; |
|
UPDATE coel_personne |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'PAG','2016') |
WHERE cp_truk_telephone LIKE '%PAG%'; |
|
|
|
|
|
|
|