some finger trouble there.. that SELECT should be: SELECT criteria_description FROM VenueSelectionCriteria ORDER BY CASE WHEN criteria_description="table space" THEN 1 WHEN criteria_description="good audio visuals" THEN 2 WHEN criteria_description="comfy seating" THEN 3 END ASC