Need to select people whose name starts with "M" or the second from the end letter of the last name is "i"? The column has persons name, surname

My table in SQL has a column with persons name and surname like "Mike Baldwin", "Sara Larson" etc. and need to output all the persons whose name starts with "M" or surnames second last letter is "i". How do I write it in script file?

So I made this script :

SELECT * WHERE CLIENT LIKE 'M%' OR CLIENT LIKE '%i_'

but this script outputs persons whose second last letter of the name is also "i".

As I understand; name and surname are two different columns based on your explanation;

select *
from table_name
where name like'M%' OR surname like '%i_';

Shall work.

Please replace the actual column names in above query

============================================================

Update :
Based on explanation;
There a single column client which stores name and surname seperated by a space

select *
from table_name
where SUBSTR(client, 1, 1) = 'M'
   OR SUBSTR(client, INSTR(client, ' ', -1) - 1, 1) = 'i';

Thinking use some Regex here. Something like but I don't know how regex works in oracle?

SELECT *
FROM table_name
 WHERE CLIENT LIKE 'M%' OR 
REGEX_LIKE (CLIENT , '^[a-zA-Z]+\s.[i]+[a-zA-Z]*$')

Updated the regex!