SELECT * FROM campus_master WHERE campus_id!='27' and campus_status='Y' order by field(campus_id,'1','23','24','27','25','26')