This is the select statement in MySql to get records in order with parent and child view.
SELECT *, CONCAT( if(parent_id > 0,(select display_order from `table_a` C where C.id = P.parent_id),''), if(parent_id > 0,'-',''), display_order ) AS new_col FROM `table_a` P order by new_col
Leave a comment
Posted in MySql
Tagged child, concat, database, display order, MySql, order, order by, parent
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Join 4,170 other followers
Sign me up!