/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 vote143 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote152 views1 answer
Sql_inner_join
SQL
4 votes87 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
1 vote115 views1 answer
Real world example of nosql
SQL
0 vote118 views2 answers
Postgresql create role
SQL
1 vote144 views1 answer
Sql sort column by date
SQL
5 votes217 views2 answers
Mysql date greater than 30 days
SQL
2 votes125 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote133 views1 answer
Mysql events not work
SQL
0 vote119 views1 answer
Oracle create package body
SQL