根据满足的条件对行进行排序？

根据满足的条件对行进行排序？

这样的事情应该起作用：

SELECt * FROM peopleORDER BY  CASE WHEN name LIKE "I%" THEN 0    WHEN name LIKE "%ster" THEN 1    WHEN name LIKE "%lo%" THEN 2 ELSE 3 END ASC;

在Access中，您可能必须诉诸嵌套

IIF()

s：

ORDER BY  IIF( name LIKE "I%",     0,  IIF( name LIKE "%ster%", 1,  IIF( name LIKE "%lo%",   2,    3  ) ) ) ASC