MySQL 8.0

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

CREATE tABLe A (ab varchar(20))
INSERT INTO A VALUES
    ('XXX ZZZ 1.1'),
   ('XXX 1.1')
SELECT SUBSTRING_INDEX(ab,' ', -1) FROM A


SUBSTRING_INDEX(ab,' ', -1)


1.1

1.1