How to insert space after each number in a string MariaDB

Question

I have a string and I need to insert a space after each number.

e.g. Ctn/10Btl/100ml to be converted it to Ctn/10 Btl/100 ml.

Can you help me how to query to insert space after number?

Any help is appreciated.

Thanks

Answer 1

You could use REGEXP_REPLACE with a capture group:

SELECT REGEXP_REPLACE('Ctn/10Btl/100ml', '(\\d+)(\\D)', '\\1 \\2')
FROM yourTable;

Output: Ctn/10 Btl/100 ml

Demo