I have this table, in which the order_name was randomly typed. I want to extract the order code after 437.
for 22 characters in their original format, e.g. 437.8/03-87 22LA190028
(it was wrongly written in the second record).
id | order_name |
---|---|
1 | First order 437.8/03-87 22LA190028 |
2 | Second order 437.8-03-87 22LA190028 |
3 | First order 437.3/10-87 16NY100013 - Return |
4 | Order 21.02.2022 437.8/10-87 16WA239766 |
5 | 437.8/10-87 16NY100234 - Paid |
6 | First order (437.8/03-87 22LA190028) |
7 | Visit 02.02.2023 Order 437.5/10-87 16DC107765 |
I will really appreciate your help.