/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 vote129 views1 answer
Mysqlimport
SQL
0 vote121 views1 answer
Sql contains numeric characters
SQL
1 vote126 views1 answer
Show indices in mysql table
SQL
0 vote141 views1 answer
Get create sql of hibernqte entity
SQL
5 votes289 views2 answers
How to ascending order in sql
SQL
0 vote122 views1 answer
Mysql where in keep order
SQL
12 votes140 views5 answers
Sql primary key
SQL
1 vote86 views1 answer
How to run sql script
SQL
6 votes133 views2 answers
Oracle trigger
SQL
2 votes123 views2 answers
Sqlalchemy filter or
SQL