The below query does not resolve my issue, pls help me out this problem
$query = “select * FROM ourteam ORDER BY FIELD(Designation, ‘Principal’,’PGT’,’TGT’,’Computer Teacher’,’Vocational Teacher’,’Special Teacher’,’ABRC’,’LA’,’Clerk’) DESC”;
table name = ourteam
Column name = Designation
I want to sort data according to fields i.e. Principal, PGT, TGT etc.
New contributor
Rajbir Parjapat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.