/SQL/Order child below the parent in mysqli

Order child below the parent in mysqli

# If no-parent = 0 instead of null 
SELECT CONCAT(IF(parent = 0,'',CONCAT('/',parent)),'/',id) AS gen_order
FROM table 
ORDER BY gen_order

#and if no-parent = null
ORDER BY COALESCE(parent, id), parent IS NOT NULL, id

Source: stackoverflow.com

Similar codes

3 votes175 views1 answer
Force using index oracle
SQL
0 vote141 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
22 votes161 views3 answers
Year format in date mysql
SQL
0 vote144 views1 answer
VSCode SQL Server Connection error
SQL
1 vote144 views1 answer
Sql myisam vs innodb
SQL
0 vote270 views1 answer
How to find the most occuring in SQL
SQL
10 votes102 views2 answers
Django mysql
SQL
-1 vote142 views1 answer
How to use update trigger in sql
SQL
0 vote146 views1 answer
Mysql select last 15 minutes
SQL
0 vote162 views1 answer
How we can perform acid Operations in sql with examples
SQL