这样的事情应该起作用：
SELECT * FROM people
ORDER 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
602392714
清零编程群