Posts by Anônimo • 11 points

• 0

  votes

  2

  answers

  294

  views

  A: Take field letters in MYSQL

  With the link sent by R. Santos, I was able to create my Function that worked: DELIMITER $$ CREATE FUNCTION `meubanco`.`GetNumber` (field varchar(100)) RETURNS VARCHAR(100) BEGIN DECLARE ls INTEGER;…

  mysql sql select

  answered 5 years, 10 months ago Anônimo 11

• 1

  votes

  2

  answers

  294

  views

  Q: Take field letters in MYSQL

  I have a field with information in this pattern: "PLC__Line" 34355655413.3912. What can I use to take out the letters, _ and " in a select, leaving only the numbers and the dot? In Postgresql I know…

  mysql sql select

  asked 5 years, 10 months ago Anônimo 11