Code HTML:
mysql -D DATABASE_NAME -e "UPDATE TABLE SET params = REGEXP_REPLACE(params, '"clubcode":".+?"', '"clubcode":"TOTO"') WHERE element = 'CHAINE'"
mysql -D DATABASE_NAME -e "UPDATE TABLE SET params = REGEXP_REPLACE(params, '"clubcode":".+?"', '"clubcode":"TOTO"') WHERE element = 'CHAINE'"
mysql -D DATABASE_NAME -e "UPDATE TABLE SET params = REGEXP_REPLACE(params, '"clubcode":".+"', '"clubcode":"TOTO"') WHERE element = 'EXTENSION'"
{"com_difficulty":"3","clubcode":"TOTO"}
{"com_difficulty":"3","clubcode":"TOTO","shownews":"1","com_calViewName":"flat"," darktemplate":"0"}
{"com_difficulty":"3","clubcode":"546465-595gfd-gfgfds65-5654gfd","shownews":"1","com_calViewName":"flat"," darktemplate":"0"}
{"com_difficulty":"3","clubcode":"fg5gfdgfq-grefdg-gredfgfd","shownews":"1","com_calViewName":"flat", "darktemplate":"0"}
mysql -D DATABASE_NAME -e "UPDATE TABLE SET params = REPLACE(params, '%OLD_CODE%', 'NEW_CODE') WHERE element = 'EXTENSION'"
Laisser un commentaire: