/* place at bottom */ SELECT * FROM categories ORDER BY name='Other', name ASC; /* place at top */ ORDER BY FIELD(name, 'English/US', 'English/UK', name), name ASC;