Substring or split

MySQL don’t now an explode or split function. But you can use SUBSTRING_INDEX:

This gets Testweg for street_name and 881 for street_nbr if caet_ast.value was “Testweg\n 881”. The function is also nestable:

This makes 3 if path was 1/3/342/357/363.