Display only first name from table field that says "First Name Last Name"?

Question

SQL

In the database, the names and surnames of all family members (table FamilyMembers) are stored in the format "first name last name" (field member_name). It is necessary to separate them and display only the names.

I did it like this:
SELECT SUBSTRING(member_name, 1, LOCATE(' ', member_name)) as firstName FROM FamilyMembers

However, for some reason, this is not correct. Help me please

Answer 1

Ah, I understand. Remove the space at the end:
SELECT SUBSTRING(member_name, 1, LOCATE(' ', member_name)-1) as firstName FROM FamilyMembers