/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 vote106 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
49 votes175 views6 answers
Get duplicate records in sql
SQL
0 vote100 views1 answer
How to check if there is no database schema
SQL
1 vote109 views1 answer
Sql count value greater than
SQL
3 votes102 views1 answer
Mysql load sql from file
SQL
0 vote132 views2 answers
Insert data into multiple tables mysql
SQL
0 vote105 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote105 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote95 views1 answer
Suse start MySQL
SQL