How to split a string in Mysql?

Question

My Mysql database contains a table t_usuario with a column nome, where there is a record with the name Gustavo Henrique Almeida Martins.

How can I make a SELECT to return only the name Gustavo?

id_usuario	name
1	Gustavo Henrique Almeida Martins

Answer 1

You can use the function SUBSTRING_INDEX.

The first parameter is the value you want to divide, the second is by which character the string will be divided and the third is which of the cut values you want.

SELECT
   SUBSTRING_INDEX(NOME, ' ', 1) AS PrimeiroNome
FROM USUARIOS

^{See working on SQL Fiddle}

Answer 2

I believe it will help:

SELECT
    SUBSTRING_INDEX(SUBSTRING_INDEX(nomecompleto, ' ', 1), ' ', -1)  AS primeironome
    ,TRIM( SUBSTR(nomecompleto, LOCATE(' ', nomecompleto)) ) AS sobrenome 
FROM
    suatabela

SQL Fiddle