这样的事情应该起作用：
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
