| 1471 |
cyprien |
1 |
|
|
|
2 |
|
|
|
3 |
/****************************************************
|
|
|
4 |
COLLECTION BOTANIQUE
|
|
|
5 |
*****************************************************/
|
|
|
6 |
|
|
|
7 |
|
|
|
8 |
/* Champ ccb_truk_degradation_specimen */
|
|
|
9 |
|
|
|
10 |
SET @valeur = '%Très important [1]%';
|
|
|
11 |
UPDATE coel_collection_botanique
|
|
|
12 |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très important [1]','30748')
|
|
|
13 |
WHERE ccb_truk_degradation_specimen LIKE '%Très important [1]%';
|
|
|
14 |
|
|
|
15 |
SET @valeur = '%Important [2]%';
|
|
|
16 |
UPDATE coel_collection_botanique
|
|
|
17 |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Important [2]','30749')
|
|
|
18 |
WHERE ccb_truk_degradation_specimen LIKE '%Important [2]%';
|
|
|
19 |
|
|
|
20 |
SET @valeur = '%Moyen [3]%';
|
|
|
21 |
UPDATE coel_collection_botanique
|
|
|
22 |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Moyen [3]','30750')
|
|
|
23 |
WHERE ccb_truk_degradation_specimen LIKE '%Moyen [3]%';
|
|
|
24 |
|
|
|
25 |
SET @valeur = '%Faible [4]%';
|
|
|
26 |
UPDATE coel_collection_botanique
|
|
|
27 |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Faible [4]','30751')
|
|
|
28 |
WHERE ccb_truk_degradation_specimen LIKE '%Faible [4]%';
|
|
|
29 |
|
|
|
30 |
SET @valeur = '%Très faible [5]%';
|
|
|
31 |
UPDATE coel_collection_botanique
|
|
|
32 |
SET ccb_truk_degradation_specimen=REPLACE(ccb_truk_degradation_specimen,'Très faible [5]','30752')
|
|
|
33 |
WHERE ccb_truk_degradation_specimen LIKE '%Très faible [5]%';
|
|
|
34 |
|
|
|
35 |
|
|
|
36 |
/* Champccb_truk_degradation_presentation */
|
|
|
37 |
|
|
|
38 |
UPDATE coel_collection_botanique
|
|
|
39 |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très important [1]','30748')
|
|
|
40 |
WHERE ccb_truk_degradation_presentation LIKE '%Très important [1]%';
|
|
|
41 |
|
|
|
42 |
|
|
|
43 |
UPDATE coel_collection_botanique
|
|
|
44 |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Important [2]','30749')
|
|
|
45 |
WHERE ccb_truk_degradation_presentation LIKE '%Important [2]%';
|
|
|
46 |
|
|
|
47 |
|
|
|
48 |
UPDATE coel_collection_botanique
|
|
|
49 |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Moyen [3]','30750')
|
|
|
50 |
WHERE ccb_truk_degradation_presentation LIKE '%Moyen [3]%';
|
|
|
51 |
|
|
|
52 |
|
|
|
53 |
UPDATE coel_collection_botanique
|
|
|
54 |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Faible [4]','30751')
|
|
|
55 |
WHERE ccb_truk_degradation_presentation LIKE '%Faible [4]%';
|
|
|
56 |
|
|
|
57 |
|
|
|
58 |
UPDATE coel_collection_botanique
|
|
|
59 |
SET ccb_truk_degradation_presentation=REPLACE(ccb_truk_degradation_presentation,'Très faible [5]','30752')
|
|
|
60 |
WHERE ccb_truk_degradation_presentation LIKE '%Très faible [5]%';
|
|
|
61 |
|
|
|
62 |
|
|
|
63 |
/****************************************************
|
|
|
64 |
PERSONNE
|
|
|
65 |
*****************************************************/
|
|
|
66 |
|
|
|
67 |
UPDATE coel_personne
|
|
|
68 |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FAX','30747')
|
|
|
69 |
WHERE cp_truk_telephone LIKE '%FAX%';
|
|
|
70 |
|
|
|
71 |
UPDATE coel_personne
|
|
|
72 |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'GSM','2014')
|
|
|
73 |
WHERE cp_truk_telephone LIKE '%GSM%';
|
|
|
74 |
|
|
|
75 |
UPDATE coel_personne
|
|
|
76 |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'FIX','2015')
|
|
|
77 |
WHERE cp_truk_telephone LIKE '%FIX%';
|
|
|
78 |
|
|
|
79 |
UPDATE coel_personne
|
|
|
80 |
SET cp_truk_telephone=REPLACE(cp_truk_telephone,'PAG','2016')
|
|
|
81 |
WHERE cp_truk_telephone LIKE '%PAG%';
|
|
|
82 |
|
|
|
83 |
|
|
|
84 |
|
|
|
85 |
|
|
|
86 |
|
|
|
87 |
|
|
|
88 |
|