MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT '0630 3062' REGEXP '^[0-9]{4} [[:space:]] [0-9]{4}$';

'0630 3062' REGEXP '^[0-9]{4} [[:space:]] [0-9]{4}$'

0

SELECT 'Employee 346 retrad: 0630 3062' REGEXP '[0-9]{4} [[:space:]] [0-9]{4}';

'Employee 346 retrad: 0630 3062' REGEXP '[0-9]{4} [[:space:]] [0-9]{4}'

0

SELECT 'Employee 346 retrad: 0630 3062' REGEXP '[0-9]+ [[:space:]] [0-9]+';

'Employee 346 retrad: 0630 3062' REGEXP '[0-9]+ [[:space:]] [0-9]+'

0

SELECT 'Employee 346 retrad: 0630 3062 1657 in July Assessment' REGEXP '[0-9]+ [[:space:]] [0-9]+';

'Employee 346 retrad: 0630 3062 1657 in July Assessment' REGEXP '[0-9]+ [[:space:]] [0-9]+'

0