Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- id,
- CONCAT(
- REPEAT( ' ', (
- LENGTH( ezr_tours_hotels.path_ids ) -
- LENGTH( REPLACE( ezr_tours_hotels.path_ids, '/', '' ) )
- ), ezr_tours_hotels.fa_name )
- ) AS tree
- FROM ezr_tours_hotels
- ORDER BY ezr_tours_hotels.path_ids ASC
- Alternative
- SELECT
- id,
- CONCAT(REPEAT(' ', path_length - stripped_path_length), fa_name) AS tree
- FROM (
- SELECT
- id,
- path_ids
- LENGTH(path_ids) AS path_length,
- LENGTH(REPLACE(path_ids, '/', '')) AS striped_path_length,
- fa_name
- FROM ezr_tours_hotels
- )
- ORDER BY path_ids ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement