mise a jour field link

oooo understand !!!! maybe stupid question, but why string is shorter of 1 caracter than string itself ? :
echo " eur-lex.europa.eu/LexUriServ/LexUriServ....1234:20110101:EN:PDF " | wc -c
88
echo " eur-lex.europa.eu/legal-content/EN/TXT/P...X:32013R1308&from=EN " | wc -c
80

Then, this means that I cannot do massive update if I need to update only part of URL as :
UPDATE `emkd_flexicontent_fields_item_relations`
SET `value` = replace(value, ' www.asean-gidatabase.org/sites/default ', ' www.asean-gidatabase.org/gidatabase/sites/default ')

The only way would be to script something which would recalculate the final lenght with new url part, right ?!

sorry to bohter you, but this is a really important matter. Is there any way to change only part of the URL or due to string lenght, there is no choice to do some script ?

i didn't think .... sorry