Senthilkumar Posted February 8 Share Posted February 8 (edited) Dear Team, I have a data table. I want to display the table, which I have selected first and others next. My actual table is Wheni I select Senthil, then it should display if i select Srilekha Can any one help how to write query for displaying like this? Edited February 8 by Senthilkumar Quote Link to comment https://forums.phpfreaks.com/topic/317794-mysql-table-display-selected-data-first-and-others-are-next/ Share on other sites More sharing options...
Barand Posted February 8 Share Posted February 8 A boolean expression resolves to 0 (false) or 1 (true). Use one in your sort. ORDER BY employee <> 'Senthil', category Quote Link to comment https://forums.phpfreaks.com/topic/317794-mysql-table-display-selected-data-first-and-others-are-next/#findComment-1614969 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.