Mysql how to remove all text from a column after a space?

Question

MySQL

Hello.
There is a column in which names and surnames are indicated.



Please tell me a query with which you can delete all text after a space, i.e. get rid of the names.

I have no knowledge at all.
I was looking for manuals, but there are some complex tasks, but I don’t know how to implement such a simple one.

Answer 1

solution
UPDATE `my_table`
SET `name` = SUBSTRING_INDEX(`name` , ' ', 1),

Answer 2

UPDATE `my_table`
SET `name` = REGEXP_REPLACE(`name`, '\s.+', '')