Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. SELECT
  2.     id,
  3.     CONCAT(
  4.         REPEAT( ' ', (
  5.             LENGTH( ezr_tours_hotels.path_ids ) -
  6.             LENGTH( REPLACE( ezr_tours_hotels.path_ids, '/', '' ) )
  7.         ), ezr_tours_hotels.fa_name )
  8.     ) AS tree
  9. FROM ezr_tours_hotels
  10. ORDER BY ezr_tours_hotels.path_ids ASC
  11.  
  12.  
  13. Alternative
  14.  
  15. SELECT
  16.     id,
  17.     CONCAT(REPEAT(' ', path_length - stripped_path_length), fa_name) AS tree
  18. FROM (
  19.     SELECT
  20.         id,
  21.         path_ids
  22.         LENGTH(path_ids) AS path_length,
  23.         LENGTH(REPLACE(path_ids, '/', '')) AS striped_path_length,
  24.         fa_name
  25.     FROM ezr_tours_hotels
  26. )
  27. ORDER BY path_ids ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement