/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

0 vote145 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote125 views1 answer
Delete triger pl pg sql
SQL
1 vote152 views1 answer
Mysql show long running queries
SQL
0 vote159 views1 answer
Mysql grant user wildcard database
SQL
0 vote282 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote134 views1 answer
Mariadb cast null to 0
SQL
0 vote129 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
2 votes130 views1 answer
Sql update \
SQL
0 vote135 views2 answers
Script all indexes in a database
SQL
0 vote137 views7 answers
10 random questions use python and SQL
SQL