First and Last word in string

[Eder Pardeiro Eder Pardeiro]

Hi,

I do not know MySQL very well, I know a little more about SQLServer and I'm having a hard time resolving an issue.

I have a table with a column of names where I need the query to return only the first and last name.

For example: José Joaquim da Silva Xavier
Output: José Xavier

In SQLServer I would do so:

_________________________

select
substring(FullName,1,CHARINDEX(' ',FullName)) + Reverse(substring(REVERSE(FullName),1,CHARINDEX(' ',REVERSE(FullName))))
from People

_________________________

How I make this in MySQL?

PS: I'm Brazilian and I do not speak English, I hope you understood.