Posts by user23982 • 21 points

• 2

  votes

  7

  answers

  54187

  views

  A: Remove letters and special characters in a select

  Do the following: UPDATE CLIENTES SET CPF = REPLACE (CPF, '-' , '') And then UPDATE CLIENTES SET CPF = REPLACE (CPF, '.' , '') All right, it’ll just be the numbers.…

  mysql select-sql

  answered 9 years, 2 months ago user23982 21