/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

2 votes304 views1 answer
Columns Present in a table
SQL
0 vote310 views2 answers
Search stored procedures by name
SQL
0 vote322 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote312 views1 answer
Load mysql dumb
SQL
9 votes298 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote300 views1 answer
Sqlalchemy sequence postgresql
SQL
2 votes343 views1 answer
Oracle find constraints referencing a table
SQL
0 vote292 views1 answer
How to check default value of column in sql server
SQL
4 votes312 views1 answer
Wildcard in sql
SQL
-1 vote304 views1 answer
Insert results of a stored procedure into a temporary table
SQL