Order taxonomy from name

Submitted by root on Tue, 11/23/2021 - 20:20


SELECT tid, langcode, name, SUBSTRING_INDEX(name, ' ', 1), SUBSTRING_INDEX(TRIM (TRAILING '.' FROM SUBSTRING_INDEX(name, ' ', 1)), '.', -1) pisu FROM taxonomy_term_field_data WHERE vid = 'sailkapen' 
UPDATE taxonomy_term_field_data SET weight = SUBSTRING_INDEX(TRIM (TRAILING '.' FROM SUBSTRING_INDEX(name, ' ', 1)), '.', -1) WHERE vid = 'sailkapen'