mysql - "ORDER BY FIELD"错误

Question

我在 MYSQL 中写了一个查询:

SELECT DISTINCT MeasurementRowIndex, X, Y, Z 
FROM GeneralResultsTable 
WHERE MainDataIndex IN (1, 2) 
ORDER BY FIELD(MeasurementRowIndex , 2, 4, 3, 1, 7, 8, 6, 5)

我得到:

'FIELD' is not recognized built-in function name.

有什么想法吗？

Answer 1

如果 FIELD() 在您的 MySQL 版本中不可用，那么您必须解释 MeasurementRowIndex 并将其转换为升序的数字:

SELECT DISTINCT MeasurementRowIndex, X, Y, Z FROM GeneralResultsTable WHERE MainDataIndex IN (1, 2) 
ORDER BY CASE MeasurementRowIndex 
  WHEN 2 THEN 1 
  WHEN 4 THEN 2 
  WHEN 3 THEN 3 
  WHEN 1 THEN 4 
  WHEN 7 THEN 5 
  WHEN 8 THEN 6 
  WHEN 6 THEN 7 
  WHEN 5 THEN 8 
END