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.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

This site uses Akismet to reduce spam. Learn how your comment data is processed.