order-by
Order by com List<>
Is it possible to effect a OrderBy on a List<> by setting the value for comparison?
Example:
mRel.OrderBy(s => s. ... => s.Status == EnumModel.StatusGeral.Novo)
.ThenBy(s => s.Status == EnumModel.StatusGeral.Falha).ToList();
Sort a select in MySql by a letter
How can I make a SELECT query in MySQL that sorts the results and initially presents those that start with a specific letter? ... the letter P:
Paulo
Patricia (1st the ones that start with the letter)
Philip (2nd those who have the letter in the middle)