MySQL 5.5

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

create table contact (Name text);
insert into contact values ('Ram Ram Ram'),('Ram'),('Ram Mohan'),('Ram Lal Mohan'),('Ram K Lal Mohan');

Records: 5  Duplicates: 0  Warnings: 0


select
    Name,
    trim(left(Name,char_length(Name)-char_length(substring_index(Name,' ',-1)))) first_name,
    substring_index(Name,' ',-1) last_name
from contact


Name
first_name
last_name


Ram Ram Ram
Ram Ram
Ram

Ram

Ram

Ram Mohan
Ram
Mohan

Ram Lal Mohan
Ram Lal
Mohan

Ram K Lal Mohan
Ram K Lal
Mohan


SELECT
    Name,
    REPLACE(Name, CONCAT(' ', SUBSTRING_INDEX(Name,' ', -1)), '') AS first,
    SUBSTRING_INDEX(Name,' ', -1) AS last
FROM contact;


Name
first
last


Ram Ram Ram
Ram
Ram

Ram
Ram
Ram

Ram Mohan
Ram
Mohan

Ram Lal Mohan
Ram Lal
Mohan

Ram K Lal Mohan
Ram K Lal
Mohan

Name	first_name	last_name
Ram Ram Ram	Ram Ram	Ram
Ram		Ram
Ram Mohan	Ram	Mohan
Ram Lal Mohan	Ram Lal	Mohan
Ram K Lal Mohan	Ram K Lal	Mohan