/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 vote297 views1 answer
Vbscript connect mssql
SQL
0 vote290 views1 answer
Print boolean in plsql
SQL
2 votes265 views1 answer
Date_format for time sql
SQL
2 votes273 views1 answer
Sql count having
SQL
2 votes290 views1 answer
Sqlite3 show columns name
SQL
0 vote292 views1 answer
Top 3 salary in sql
SQL
0 vote279 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote299 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
13 votes263 views2 answers
Sqlite rename column
SQL
0 vote308 views1 answer
How to pass list as parameter in SQL query
SQL