Posts by Washington Borges • 34 points

• 1

  votes

  2

  answers

  264

  views

  A: Remove First Name and Last Name from Full Name

  Try something like that: select SUBSTRING_INDEX(nome_completo, ' ', 1) as primeiro_nome, SUBSTRING(nome_completo,LOCATE(' ',nome_completo) + 1,char_length(nome_completo) - LOCATE(' ',…

  mysql sql database sql-server string-concatenation

  answered 5 years, 2 months ago Washington Borges 34

• 0

  votes

  1

  answer

  50

  views

  A: Update via POST showing error

  As a good practice avoid concatenating string in SQL commands. Always choose to use the prepare statement to manipulate the database, this way you avoid possible SQL Injection attacks. Read the…

  mysqli

  answered 5 years, 2 months ago Washington Borges 34