What is the syntax for creating a regular expression for a calculated field in MySQL?

Question

MySQL

Hello, I'm not sure if this is faster than with PHP (but there will be no extra spacers), but I would like to know. How can I write a regular expression for a calculated field in a MySQL table.
Banal example:
| id | address | street | home |
| 1 | g. Mocsow, ul. Sadovaya, h. 24, | ? | ? |
| 2 | g. Mocsow, pr. Dezhnva, h. 23 , | ? | ? |
Well, it’s appropriate to get a street and a house. into separate fields.
The line format is as follows: Ukhta, st. Gorky, d. 6
In principle, it is normalized and you can cling to the fact that before "," and the number of occurrences.

Answer 1

Regular expressions in MySQL are used only as a "matches a mask" boolean function. There is no selection of substrings or their replacement.