At the moment we use the street 1 field for the house number in our Magento 2.3.5 store.
But we want to revert this and only use 1 street field for both the street and house number. So we need to move all values from the street 1 field after the current values into the street 0 field.
In the database it is not just a new field, its just a new line in the street column. So it seems that we just need to add it to the same line.
How can we easily and safely achieve this? Can we perform this using an sql?