We have a database with column called street, this field now contains both street and house number on one line. We need to have the house number on the second line in the same column.
So now the column is like:
And it needs to be:
I have a regex available to split the street field. I dont think I can use this directly in phpMyAdmin orso, but I guess we should be able to create a small script to get the street value and resave it with a new line (
Hopefully someone can help us out!