[SQL] string matching for first name and last name characters

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".

Continue reading...