obtener_valor_por_id, MySQL

Language: Layout:

DROP TABLE IF EXISTS tu_tabla;

CREATE TABLE  IF NOT EXISTS tu_tabla
        (
          id          INT,
          name varchar(200),
          path varchar(20)
        );

INSERT INTO tu_tabla (id, name, path) VALUES  
        (1, 'valor 1', '/1'), 
        (2, 'valor 2', '/1/2'), 
        (3, 'valor 3', '/1/2/3'), 
        (4, 'valor 4', '/1/2/4'), 
        (5, 'valor 5', '/1/5'), 
        (6, 'valor 6', '/1/2/4/6');

DROP FUNCTION IF EXISTS mostrar_path;
CREATE FUNCTION mostrar_path(path varchar(50)) RETURNS VARCHAR(1000)
BEGIN
  DECLARE len_path integer;
  declare mostrar_path varchar(1000) default "";
  declare path_por_id varchar(100) default "";
  declare contador integer default 1;
  set len_path = char_length(path);
  
  while contador <= len_path do
      if substring(path, contador, 1) != "/" then
          select name into path_por_id from tu_tabla where id = convert(substring(path, contador, 1), signed integer);
          set mostrar_path = concat(mostrar_path,concat( "/" , path_por_id));
      end if;

set contador = contador + 1;
  end while;

RETURN mostrar_path;
END;

SELECT  id, name, path, mostrar_path(path)
    FROM  tu_tabla;


absolute service time: 0,39 sec