/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

1 vote338 views1 answer
Mysql show attributes of a table
SQL
0 vote310 views1 answer
Install ms sql server management studio
SQL
3 votes311 views3 answers
Mysql get table size
SQL
28 votes372 views6 answers
Sql update
SQL
2 votes327 views6 answers
In operator in sql
SQL
13 votes329 views4 answers
Command line mysql import
SQL
0 vote317 views1 answer
Get number of tables in database sql
SQL
0 vote326 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote348 views1 answer
Vbscript connect mssql
SQL
0 vote285 views2 answers
Influxdb delete measurement based on date
SQL