MySql – Conditional display order


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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s