alcatrazbr
1/6/2017 - 3:47 AM

select first and rest word, first name last name

select first and rest word, first name last name

SELECT nome, 
      SUBSTRING_INDEX(nome, ' ', 1), 
      SUBSTRING(nome, LOCATE(' ', nome))  FROM motorista m