Posts by Breno Oliveira • 11 points

• 1

  votes

  2

  answers

  1020

  views

  A: Format ZIP in Query - Mysql

  The simplest form I believe is using CONCAT() together with SUBSTRING: SELECT CONCAT(SUBSTRING(CEP,1,2),'.',SUBSTRING(CEP,3,3),'-',SUBSTRING(CEP,6,3)) FROM {suatabela} WHERE ... It will work if…

  mysql

  answered 4 years, 8 months ago Breno Oliveira 11