SELECT * FROM table ORDER BY decode( name, 'value1', 1, 'value2', 2, 'value3', 3, 'value4 ', 4, valueN', N )