MySQL-如何按相对顺序排序？INNODB表

版本1：

SELECt max(id) id, name  FROM cards WHERe name like '%John%' GROUP BY name ORDER BY CASE WHEN name like 'John %' THEN 0    WHEN name like 'John%' THEN 1    WHEN name like '% John%' THEN 2    ELSE 3          END, name

版本2：

SELECt max(id) id, name  FROM cards WHERe name like '%John%' GROUP BY name ORDER BY CASE WHEN name like 'John%' THEN 0    WHEN name like '% %John% %' THEN 1    WHEN name like '%John' THEN 2    ELSE 3          END, name