Suppose we have 10000 records of any product. User search on our website with his given criteria. so we output search results based on given criteria.
Now Admin want to rank products in search. so simple thing is to make order field on product table and order by it in query.
So is there any alternative and best ways for it?